update s set s.skudesc = gs1.shortdescription from tbl_PRD_Skus s with (nolock) inner join tbl_PRD_Packaging p with (nolock) on p.linkid = s.skuid and p.linkType = 'SKU' inner join gs1..tbl_Gs1_Items_0077013000013 gs1 with (nolock) on gs1.GTIN = p.scc14 where s.ownerid = 1382 and s.fsl_tableCode = 'MFR' and isDate(gs1_syncDate) = 1 and nullif(gs1.shortdescription,'') is not null