Uzupelnienie lastLocationID
--Uzupe�nia lastLocationID w wms.item
UPDATE wms.item SET lastlocationID = s.lastlocationid FROM (SELECT DISTINCT x.itemID, x.lastLocationId FROM (SELECT itemID, [lastlocationID], modDate FROM [wms].[stockBalance]) x INNER JOIN (SELECT itemID, MAX(modDate) md FROM [wms].[stockBalance] WHERE lastLocationId IS NOT NULL GROUP BY itemID) y ON x.itemID = y.itemID AND x.modDate = y.md) s JOIN wms.item i ON s.itemID = i.itemID