--FIX
--update document.documentLine set documentFullNR = d.documentFullNR
--CHECK
select d.documentFullNR N, dl.documentFullNR P, d.documentDate
from
document.documentLine dl
inner join document.document d on d.documentID =dl.documentid
inner join wms.item i on dl.itemid =i.itemid
left join wms.commisionLine cl on dl.commisionLineID = cl.commisionLineID
left join wms.commision c on c.commisionID =cl.commisionID
where
dl.documentFullNR != d.documentFullNR
order by
documentDate,dl.sign desc
