quote:

---

Then from that temporary table I have to loop from each data to parse a resulting SQL statement to be executed dynamically. The only thing that comes in my mind in looping through the records inside the Temporary table is through cursor, is there other way to do this?

---

--Create a temp table #MyTemp (not a real table) - look up temp tables in BOL
--[ID] int identity(1,1) is like an autonumber column in Access
	CREATE TABLE #MyTemp ([ID] int identity(1,1), SQL varchar(100))

--Insert some values into the temp table to make it work
	INSERT #MyTemp (SQL)
		SELECT 'SELECT * FROM Orders' UNION ALL
		SELECT 'SELECT * FROM Customers' UNION ALL
		SELECT 'SELECT * FROM Employees' UNION ALL
		SELECT 'SELECT * FROM Products'

--Look at the contents of the temp table 
	SELECT * FROM #MyTemp
		Results:
			ID          SQL                                                                                                  
			1           SELECT * FROM Orders
			2           SELECT * FROM Customers
			3           SELECT * FROM Employees
			4           SELECT * FROM Products

--Declare variables (from here is the bit you should concentrate on)
	DECLARE @ID int, @SQL varchar(100)
--Set @ID to the lowest id (starting point)
	SET @ID = (SELECT MIN(ID) FROM #MyTemp)
--Do the next bit until @ID = 4 this is because i know that there are only 4 records
	WHILE @ID < 5
	BEGIN
--Get SQL value and put into the variable
		SET @SQL = (SELECT SQL FROM #MyTemp WHERE [ID] = @ID) 
--Execute the SQL string - EXEC can be replaced by PRINT to see what it would execute
		EXEC (@SQL)
--Add 1 to the @ID variable
		SET @ID = @ID + 1
	END

--Clean up (not really necesary with temp tables)
DROP TABLE #MyTemp

DECLARE @MinID int, @MaxID int, @SQL varchar(100)
SET @MinID = (SELECT MIN([ID]) FROM YourTable) --Minimum ID (1st record)
SET @MaxID = (SELECT MAX([ID]) FROM YourTable) --Maximum ID (last record)
WHILE @MinID <= @MaxID
BEGIN
SET @SQL = (SELECT YourSQLColumn FROM YourTable WHERE [ID] = @MinID) 
EXEC (@SQL)
SET @MinID = @MinID + 1
END