Need Help with While Loop , i trying execute two SP using while loop bu i m getting Syntax Errror

Question

DECLARE   @COUNT                                          INT,
                 @i                                                     INT,
                @InvoiceItemPremiumID                   INT,
                @InvoiceItemPeopleCommissionID   INT


SELECT @COUNT = COUNT(InvoiceItemPeopleCommissionID) 
FROM #test2

SET @i = 1
WHILE (@i < = @COUNT) 


BEGIN
SELECT @InvoiceItemPremiumID = InvoiceItemPremiumID ,
             @InvoiceItemPeopleCommissionID = InvoiceItemPeopleCommissionID 
FROM #test2
WHERE temID = @i


EXEC dbo.sp_DeletePolicyInfoPeopleCommissions @InvoiceItemPeopleCommissionID
EXEC dbo.pr_accInvDeleteInvoiceItemPremium  @InvoiceItemPremiumID


END

Answer 1

DECLARE   @COUNT                                          INT,
                 @i                                                     INT,
                @InvoiceItemPremiumID                   INT,
                @InvoiceItemPeopleCommissionID   INT


SELECT @COUNT = COUNT(InvoiceItemPeopleCommissionID) 
FROM #test2

SET @i = 1
WHILE (@i < = @COUNT) 


BEGIN
SELECT @InvoiceItemPremiumID = InvoiceItemPremiumID ,
             @InvoiceItemPeopleCommissionID = InvoiceItemPeopleCommissionID 
FROM #test2
WHERE temID = @i


EXEC dbo.sp_DeletePolicyInfoPeopleCommissions @InvoiceItemPeopleCommissionID
EXEC dbo.pr_accInvDeleteInvoiceItemPremium  @InvoiceItemPremiumID

Set @i+= 1
END

You need to increment you variable in loop. If you can provide exact error would be much better.

---

Best Wishes, Arbi; Please vote if you find this posting was helpful or Mark it as answered.

Answer 2

Show us the error you are getting

---

Dave Frommer - BI Architect - Independent

Answer 3

thanks a lot  Arbi 

yeah actually i forgot to put increment as SET @i = @i + 1

thanks once again u made my day :)

Answer 4

Thanks Dave i found the solution