61430,
Расскажи, что делает этот запрос, ведь это просто:
UPDATE [Production_dev].[dbo].[Production$Warehouse Sale2]
SET [Min_ Receipt Date] =
ISNULL((
SELECT MIN([Posting Date])
FROM [dbo].[Privat Trade$Item Ledger Entry]
WHERE [Lot No_] =
ISNULL((
SELECT MIN([Lot No_])
FROM [Privat Trade$Item Ledger Entry]
WHERE [Open] = 1
AND [Positive] = 1
AND [Item No_] = [Production_dev].[dbo].[Production$Warehouse Sale2].[Item No_]
),'')
),'1754-01-01')
WHERE [Item No_] = 'W12062907719'