Question: USE AP; SELECT * INTO #InvoiceCopy FROM Invoices; DECLARE @InvoiceID int, @InvoiceTotal money; DECLARE @Total money; SET @Total = 0 ; WHILE @Total + (
USE AP;
SELECT INTO #InvoiceCopy FROM Invoices;
DECLARE @InvoiceID int, @InvoiceTotal money;
DECLARE @Total money;
SET @Total ;
WHILE @Total SELECT TOP InvoiceTotal
FROM #InvoiceCopy
ORDER BY InvoiceTotal DESC
BEGIN
SELECT TOP @InvoiceID InvoiceID, @InvoiceTotal InvoiceTotal
FROM #InvoiceCopy
ORDER BY InvoiceTotal DESC;
IF @InvoiceTotal
BREAK;
ELSE
BEGIN
SET @Total @Total @InvoiceTotal;
DELETE FROM #InvoiceCopy
WHERE InvoiceID @InvoiceID;
END;
END;
PRINT 'Total: $ CONVERTvarchar @Total, ;
When does the expression on the WHILE statement in this script cause the loop to end?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
