T-SQL loop over query results

by

You could use a CURSOR in this case:

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

Modified to show multiple parameters from the table.

More Related Contents:

  1. SQl CASE Statement
  2. How to calculate age in T-SQL with years, months, and days
  3. Levenshtein distance in T-SQL
  4. Convert multiple rows into one with comma as separator [duplicate]
  5. Select query to remove non-numeric characters
  6. How to convert Seconds to HH:MM:SS using T-SQL
  7. T-SQL: Selecting rows to delete via joins
  8. Combining INSERT INTO and WITH/CTE
  9. T-SQL Pivot? Possibility of creating table columns from row values
  10. What is a “batch”, and why is GO used?
  11. Getting the minimum of two values in SQL
  12. How to insert default values in SQL table?
  13. T-SQL CASE Clause: How to specify WHEN NULL
  14. How to convert a “dd/mm/yyyy” string to datetime in SQL Server?
  15. t-sql get all dates between 2 dates [duplicate]
  16. Check if a varchar is a number (TSQL)
  17. How to pivot table with T-SQL?
  18. Extract the first word of a string in a SQL Server query
  19. Testing for inequality in T-SQL
  20. Can I use the MERGE statement in SQL Server 2005?
  21. Replace a newline in TSQL
  22. T-SQL – function with default parameters
  23. Search for one value in any column of any table inside a database
  24. How to use an Alias in a Calculation for Another Field
  25. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  26. Convert unix epoch timestamp to TSQL datetime
  27. T-SQL Between Dates Confusion
  28. String.Format like functionality in T-SQL?
  29. How to parse string into date?
  30. Stored procedure hangs seemingly without explanation

Leave a Comment