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 vote173 views1 answer
Query by column for substring sql
SQL
-1 vote168 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
2 votes162 views1 answer
Oracle calculated column
SQL
1 vote174 views2 answers
Mysql update table from another table
SQL
25 votes189 views4 answers
Metadata
SQL
1 vote192 views1 answer
Mysql select all and rename one
SQL
0 vote191 views1 answer
Primary key start from number
SQL
0 vote174 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote161 views1 answer
Cross apply top for each row t1
SQL
1 vote170 views1 answer
Alter add syntax
SQL