How can one call a stored procedure for each row in a table, where the columns of a row are input parameters to the sp without using a Cursor?
SQL Call Stored Procedure for each Row without using a cursor
cursorsqlsql serverstored-procedures
Related Topic
- Sql – Parameterize an SQL IN clause
- Sql – Insert results of a stored procedure into a temporary table
- Sql-server – Altering a column: null to not null
- Sql – Exclude a column using SELECT * [except columnA] FROM tableA
- Sql – Function vs. Stored Procedure in SQL Server
- Sql – Select first row in each GROUP BY group
- Sql – Search text in stored procedure in SQL Server
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
Generally speaking I always look for a set based approach (sometimes at the expense of changing the schema).
However, this snippet does have its place..