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

7 votes192 views6 answers
Mysql group concat
SQL
1 vote220 views1 answer
Postgresql append array
SQL
0 vote127 views1 answer
Oracle sql developer script output limit
SQL
0 vote191 views1 answer
Psql generate id in existing database
SQL
11 votes206 views2 answers
Import sql file laravel cmd
SQL
15 votes160 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote180 views1 answer
Oracle sql date summer time
SQL
1 vote177 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
1 vote160 views1 answer
Error code 1175 mysql fix
SQL
0 vote174 views2 answers
Psql commande \gset
SQL