For loop in SQL derver

Hi Arul,

http://www.codeproject.com/Tips/277847/How-to-use-Cursor-in-Sql link can help you

Thank you

Please using below example you can write ur code.

USE AdventureWorks;
GO
WHILE (
SELECT AVG(ListPrice)
FROM Production.Product) < $300
BEGIN
UPDATE Production.Product
SET ListPrice = ListPrice * 2
SELECT MAX(ListPrice)
FROM Production.Product
IF (
SELECT MAX(ListPrice)
FROM Production.Product) > $500
BREAK
ELSE
CONTINUE
END;

Please using below example you can write ur code.

USE AdventureWorks;
GO
WHILE (SELECT AVG(ListPrice) FROM Production.Product) < $300
	BEGIN
          UPDATE Production.Product SET ListPrice = ListPrice * 2
          SELECT MAX(ListPrice)FROM Production.Product
		IF (SELECT MAX(ListPrice) FROM Production.Product) > $500
			BREAK
		ELSE
			CONTINUE 
	END;