May 20, 2011 · For loop is not officially supported yet by SQL server. Already there is answer on achieving FOR Loop's different ways. I am detailing answer on ways to achieve different types …

The variable MAXID is used to LOOP through. The variable COUNTER is used to perform an operation on a particular record in the table. If I read the question it talks about " have a few …

Jan 1, 2010 · SQL is primarily a set-orientated language - it's generally a bad idea to use a loop in it. In this case, a similar result could be achieved using a recursive CTE: with cte as (select 1 i …

Nov 10, 2013 · Select IDs from your table and use CROSS APPLY the function with data as argument so you'll have as many rows as values contained in the current row's data. No need …

In SQL, you should generally try to write set-based code, not procedural, step by step code. So, the SQLish thing to ask for is "how do I insert 300 rows into my table, where each row gets a …

Feb 19, 2009 · A possible way that always works (even if there is no unique key available) is to use the rowid pseudocolumn: begin for i in (select rowid, emp.* from emp) loop if i.sal=1300 …

Jan 18, 2011 · CREATE TABLE #T (dbname sysname NOT NULL PRIMARY KEY, SumPGCOUNT INT, CREATED DATETIME) DECLARE @Script NVARCHAR(MAX) = '' …

The "cursors are evil" opinion is much more prominent in the SQL Server community. So I guess this answer is to switch to Oracle or give MS a clue. Oracle EXECUTE IMMEDIATE into a …

Of course, if you want to actually do something with each record in your loop (like send an email or write to a file) rather than just shuffle stuff around within SQL, you need to use a cursor or …

Dec 9, 2013 · You can use dynamic SQL and get all the column names for a table. Then build up the script: Declare @sql varchar(max) = '' declare @tablename as varchar(255) = 'test' select …