update s set s.sku = replace(s.sku,'[EA]',''), s.CustomFld_1 = '[EA]' from tbl_PRD_Skus s where s.fsl_tableCode = 'BRO' and s.ownerId = 2661 and s.sku like '%[EA]%' and s.gs1_syncdate > dateadd(hour, -1, getdate()) update s set s.sku = replace(s.sku,'[PK]',''), s.CustomFld_1 = '[PK]' from tbl_PRD_Skus s where s.fsl_tableCode = 'BRO' and s.ownerId = 2661 and s.sku like '%[PK]%' and s.gs1_syncdate > dateadd(hour, -1, getdate()) update s set s.sku = replace(s.sku,'[PL]',''), s.CustomFld_1 = '[PL]' from tbl_PRD_Skus s where s.fsl_tableCode = 'BRO' and s.ownerId = 2661 and s.sku like '%[PL]%' and s.gs1_syncdate > dateadd(hour, -1, getdate()) select s.skuid, master_height, master_height_unit, master_width, master_width_unit, master_length_unit, master_length_unit, master_cube, master_cube_unit, master_gross_weight, master_gross_weight_unit,master_net_weight, master_net_weight_unit from tbl_PRD_Skus s inner join tbl_PRD_Packaging pk on s.skuid = p.linkid and p.linkType = 'SKU' where s.fsl_tableCode = 'BRO' and s.ownerId = 2661 and gs1_syncdate > dateadd(hour, -1, getdate()) and ( master_cube_unit <> 'FTQ' or master_height_unit NOT IN ('IN','INH') or master_length_unit NOT IN ('IN','INH') or master_width_unit NOT IN ('IN','INH') ) update p set master_height_unit = , master_height_uom = , master_length_unit = , master_length_uom = , master_width_unit = , master_width_uom = , master_cube_unit = , master_cube_uom = , master_gross_weight = , master_gross_weight_unit = , master_net_weight = , master_net_weight_unit = from tbl_PRD_Packaging p inner join tbl_PRD_Skus s on p.linkid = s.skuid and linkType = 'SKU' where s.fsl_tableCode = 'BRO' and s.ownerid = 2661 and s.gs1_syncdate > dateadd(hour, -1, getdate()) update s set soldByUm = CASE WHEN soldByUm = 'CA' THEN 'CS' WHEN soldByUm = 'PL' THEN 'PT' END from tbl_PRD_Skus s where s.fsl_tableCode = 'BRO' and s.ownerid = 2661 and s.soldByUm IN ('CA','PL') and s.gs1_syncdate > dateadd(hour, -1, getdate()) update s set partNumberStatus = CASE WHEN nullif(ReplacedBy,'') is not null THEN 'Replaced' WHEN discontinueDate < getDate() or endAvailabilityDate < getDate() then 'Discontinued' ELSE 'Active' END from tbl_PRD_Skus s where s.fsl_tableCode = 'BRO' and s.ownerid = 2661 and s.gs1_syncdate > dateadd(hour, -1, getdate()) update p set p.packaging_comments = u.unit from tbl_PRD_Packaging p inner join tbl_PRD_Skus s on p.linkid = s.skuid and linkType = 'SKU' inner join tbl_PRD_UnitMeasureTypes u on u.unitAbbrev = p.packaing_comments where s.fsl_tableCode = 'BRO' and s.ownerid = 2661 and s.gs1_syncdate > dateadd(hour, -1, getdate())