>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 >>?