Can I: loop through sql select and then fire off for each loop?

Question

Hi All,

I'm probably missing something (looking at it too long), but in a stored procedure can I select all distinct values from one table and then do a for each loop based on each of those returned rows, which themselves build up sql statements based on the distinct values?

Cheers.

Answer 1

Yes, you can use a cursor.

Note that cursors are best avoided if possible. If it's possible to do what you need with a set-based query -- and it often is -- then you should do that instead.