Bank5
I have a table that contains a CourseID field and a Status field.
CourseID Status
1 NULL
2 NULL
3 NULL
I need to loop through this table and run a stored procedure on each CourseID to fill in the status field. How can I do this I'm not a big fan of cursors and hardly ever use them, but for this case, I'm not sure if there's a way around it. I'm using SQL Server 2005 btw.