Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Optimize Update Statement RE: Optimize Update Statement
wit_jp2001
SSC Veteran
Points: 242
More actions
January 24, 2014 at 9:30 am
#1683186
The SKU1 is updated with the heaviest sku in the list of SKU's.
The heaviest SKU is predetermined in SKUVAL, the weights are hidden.
So essentially it looks through the list and switches the heaviest with the first sku.
Thanks