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