VbzCart/docs/queries/qryCtg src dups
Jump to navigation
Jump to search
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 />