--aktualizacja powiaązań
update document.documentLine set inventorySheetLineId =isl.inventorySheetLineID
--select [dbo].[fn_decodeGuid](dl.inventorySheetLineId,'isl.inventorynr') ,
--[dbo].[fn_decodeGuid](isl.inventorySheetLineID,'isl.inventorynr'),
--isl.inventorySheetLineID ,isl.locationid ,dl.*
from document.documentLine dl inner join item.inventorySheetLine isl on
isnull(dl.locationid,'00000000-0000-0000-0000-000000000000') = isnull(isl.locationid,'00000000-0000-0000-0000-000000000000')
and dl.itemid = isl.itemid
where dl.inventorySheetLineId is not null
and dl.inventorySheetLineId != isl.inventorySheetLineID
--upewnienie sie ze ta sama inwentaryzacja
and isl.inventorySheetLineId in
(select i1.inventorySheetLineId from item.inventorySheetLine i1 inner join item.inventorysheet i2 on i1.inventorysheetid = i2.inventorysheetid and i2.inventoryid=@inventoryId)
and dl.status >-1
and dl.addDate > GETDATE()-20
--and dl.itemid = '049878a6-cd52-479e-a4c1-e78fcec2be66'
and dl.documentfullnr like 'WM%'
