update s set nutritionalFactPanelVersion = '3' from tbl_PRD_Skus s with (nolock) inner join tbl_PRD_Nutrition n with (nolock) on (n.nutType = 'SKU' and s.skuid = n.linkid) where s.fsl_tableCode = 'MFR' and s.ownerId = 164 and n.fsl_tableCode = 'MFR' and n.ownerId = 164 and ISNUMERIC ( n.addedSugar ) = 1 and cast( n.addedSugar as decimal(18,2) ) > 0 and s.nutritionalFactPanelVersion <> '3' and day( s.gs1_syncdate ) = day( getdate() ) and month( s.gs1_syncdate ) = month( getdate() ) and year( s.gs1_syncdate ) = year( getdate() )