>SELECT InvoiceDetail.AddDate,* FROM Invoice >CROSS APPLY (SELECT TOP 1 InvoiceDetail.Numero,InvoiceDetail.AddDate >FROM InvoiceDetail >WHERE InvoiceDetail.NoInvoice=Invoice.Numero >ORDER BY InvoiceDetail.Numero DESC) InvoiceDetail >WHERE Invoice.Status='1899-12-30 00:00:00.000' >>
>UPDATE Invoice SET Status=DispatchDetail.Status > INNER JOIN ... on ....NoInvoice=Invoice.Numero >SELECT InvoiceDetail.AddDate,* FROM Invoice >CROSS APPLY (SELECT TOP 1 InvoiceDetail.Numero,InvoiceDetail.AddDate >FROM InvoiceDetail >WHERE InvoiceDetail.NoInvoice=Invoice.Numero >ORDER BY InvoiceDetail.Numero DESC) InvoiceDetail >WHERE Invoice.Status='1899-12-30 00:00:00.000' >>
UPDATE Invoice SET Status=DispatchDetail.Status FROM Invoice INNER JOIN (SELECT InvoiceDetail.AddDate,* FROM Invoice CROSS APPLY (SELECT TOP 1 InvoiceDetail.Numero,InvoiceDetail.AddDate FROM InvoiceDetail WHERE InvoiceDetail.NoInvoice=Invoice.Numero ORDER BY InvoiceDetail.Numero DESC) InvoiceDetail WHERE Invoice.Status='1899-12-30 00:00:00.000') InvDet on InvDet.NoInvoice=Invoice.Numero?