select * from tbl_PRD_Skus s with (nolock) inner join tblManufacturers mfr with (nolock) on mfr.mfr_id = s.mfrId 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 = 'CHO' and s.ownerId in ( select cho_id from tbl_CHO_Operators with (nolock) where cho_1FSSchoolsMember = 'Y' ) and s.ownerId = and nullif( s.mfrSyncSkuId, 0 ) is null select s.ofsBidSpecId from tbl_PRD_Skus s with (nolock) where s.fsl_tablecode = and s.ownerId = and s.skuId = and nullif( s.ofsBidSpecId, '' ) is not null select ownerId, fsl_tablecode as ownerType, skuId, sku, scc14, mfr_id, mfr_name from qmd_products where isAugmented = 'Y' order by mfr_name select s.skuId from tbl_PRD_Skus s with (nolock) 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.ownerId = and s.fsl_tablecode = 'MFR' and ( p.scc14 = or s.sku = ) update tbl_PRD_Skus set mfrSyncSkuId = where ownerId = and fsl_tablecode = and skuId = COOP: #sku# #skuId# | #mfr_name#: #qmd_check.skuId#
COOP: #sku# #skuId# - More than one product. Cannot sync.
COOP: #sku# #skuId# - Not Found.