select * from qmd_products where ownerId = and ownerType = 'CHO' select * from qmd_productsByCoop where isRequested = 'N' and isAugmented = 'N' update tbl_PRD_Skus set ownerId = -ownerId where fsl_tablecode = and ownerId = and skuId = delete from tbl_OFS_FlatSearch where skuOwnerType = and skuOwnerId = and skuId = select * from qmd_productsByCoop where requestStatus in ( 'APP' ) and ( requestSentDaysOld = 1 or requestStatusDaysOld > 14 ) select s.skuId, p.scc14, p.upc from tbl_PRD_Skus s with (nolock) inner join tblManufacturers mfr with (nolock) on s.mfrId = mfr.mfr_id left outer join tbl_PRD_Packaging p with (nolock) on p.ownerId = s.ownerId and p.fsl_tablecode = s.fsl_tablecode and p.linkId = s.skuId and p.linkType = 'SKU' where s.fsl_tablecode = 'MFR' and s.ownerId = and nullif( s.gs1_syncDate, '' ) is not null and ( p.scc14 = or s.sku = ) update tbl_OFS_SkuRequests set requestStatusDate = where skuRequestId = update tbl_PRD_Skus set schoolProduct = 'Y' where fsl_tablecode = 'MFR' and ownerId = and skuId = update tbl_PRD_Skus set mfrSyncSkuId = where fsl_tablecode = and ownerId = and skuId = select * from tbl_PRD_Packaging where fsl_tablecode = and ownerId = and linkType = 'SKU' and linkId = update tbl_PRD_Packaging set scc14 = where fsl_tablecode = and ownerId = and linkType = 'SKU' and linkId = insert into tbl_PRD_Packaging ( ownerId, fsl_tablecode, linkId, linkType, scc14, upc ) values ( , , , 'SKU', , ) update tbl_OFS_SkuRequests set requestStatus = 'CPL', requestStatusDate = where skuRequestId = select cho_name from tbl_CHO_Operators with (nolock) where cho_id =

#qmd_coop.cho_name#
Products
Total Non-Augmented Products:	#val( _irrelevantProducts )#
Total Products Remaining :	#val( _finalTotalProduct )#
Placeholder Requests
Total Requests Processed:	#val( _totalItemsProcessed )#
Total Resolved Requests:	#listLen( _resolvedItems )#
Total Unresolved Requests:	#listLen( _unresolvedItems )#
Total Processing Time:	#numberFormat( val( ( _endProcessor - _startProcessor ) / 60000 ), "0" )# minutes

#results#