Sql server loop over query

DECLARE @id INT
DECLARE @name NVARCHAR(100)
DECLARE @getid CURSOR

SET @getid = CURSOR FOR
SELECT table.id,
       table.name
FROM   table

OPEN @getid
FETCH NEXT
FROM @getid INTO @id, @name
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC stored_proc @varName=@id, @otherVarName='test', @varForName=@name
    FETCH NEXT
    FROM @getid INTO @id, @name
END

CLOSE @getid
DEALLOCATE @getid

Source: stackoverflow.com

Similar codes

0 vote349 views1 answer
Mysql drop multiple tables at once
SQL
0 vote356 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote392 views1 answer
Declare or use variable in snowflake
SQL
0 vote381 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
2 votes405 views1 answer
Oracle run_duration to number
SQL
5 votes361 views2 answers
Get columns number sql
SQL
0 vote378 views1 answer
Postgresql auto increment not working
SQL
0 vote299 views1 answer
Sqlalchemy existing database
SQL
0 vote373 views1 answer
Print mysql
SQL
1 vote356 views1 answer
Mysql sort by date column
SQL