Skip to main content

All Questions

3 votes
1 answer
4k views

How to use a CTE as a loop?

Is there any way to convert this cursor into a looping/recursive CTE? I've been reading some of the articles on CTEs but they've been about hierarchies and they made my head spin. create table #...
On The Net Again's user avatar