VbzCart/docs/queries/qryCtg src dups

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: Template:Vbzcart/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

<section begin=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> <section end=sql />