IF OBJECT_ID('tempdb..#Temp') IS NOT NULL
 DROP TABLE #Temp

SELECT InvoiceDetail.NoInvoice,InvoiceDetail.Numero
 INTO #Temp
 FROM
 (SELECT MAX(InvoiceDetail.Numero) AS InvoiceDetailNumero
 FROM Invoice
 INNER JOIN InvoiceDetail ON Invoice.Numero=InvoiceDetail.NoInvoice
 WHERE Invoice.NoCompany=32
 GROUP BY InvoiceDetail.NoInvoice) Invoice2
 INNER JOIN InvoiceDetail ON Invoice2.InvoiceDetailNumero=InvoiceDetail.Numero
 WHERE InvoiceDetail.NoStatus=7 AND InvoiceDetail.AddUser=1

DECLARE @NoInvoice INT
DECLARE @NoStatus INT
DECLARE @Numero INT

WHILE (SELECT COUNT(*) FROM #Temp)>0
BEGIN

   SELECT TOP 1 @Numero=Numero,@NoInvoice=NoInvoice FROM #Temp

   IF OBJECT_ID('tempdb..#Temp2') IS NOT NULL
    DROP TABLE #Temp2
 
    SELECT TOP 1 InvoiceDetail.Numero AS InvoiceDetailNumero,InvoiceDetail.NoStatus
    INTO #Temp2
    FROM InvoiceDetail
    WHERE InvoiceDetail.NoInvoice=@NoInvoice AND InvoiceDetail.NoStatus<>7
    ORDER BY InvoiceDetail.NoInvoice

   SELECT @NoStatus=NoStatus FROM #Temp2

   IF (@NoStatus=3)
   BEGIN
      
      DELETE FROM InvoiceDetail WHERE Numero=@Numero

      UPDATE Invoice SET NoStatus=3 WHERE Numero=@NoInvoice

   END

   DROP TABLE #Temp2

   DELETE FROM #Temp WHERE Numero=@Numero
END

DROP TABLE #Temp