VbzCart/queries/qryCtg src dups

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  • Purpose: Returns all duplicate records (each IDS_Item must be unique) in the generated source data. This should be performed as a check on data integrity before writing to cat_items; any duplicates may indicate a problem (typically, entering items from a new catalog but forgetting to mark the old one as superceded), and should be inspected. (Not sure if conflicts will prevent the update from completing; to be determined later.)
  • Requires:
  1. REDIRECT Template:l/vc/query
  • Used by: catalog building process (details to be documented)
  • History:
    • 2008-03-15 Building sequence completely rewritten, so presumably this query was created then

SQL

<mysql>CREATE OR REPLACE VIEW qryCtg_src_dups AS SELECT 

 IDS_Item,
 COUNT(IDS_Item) AS cntRows

FROM qryCtg_src GROUP BY IDS_Item HAVING cntRows>1;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtg_src_dups&oldid=11725"