September 24, 2013 at 5:49 am
Jeff Moden (9/22/2013)
Erland Sommarskog (9/22/2013)
I know you can probably do such rCTEs in your sleep 😉
Actually, I had to test it, and that was a good thing, because I had the condition wrong, and kept on looping unitl I hit the default limit of 100 recurssios.
but that's an rCTE that counts and, even for small numbers of rows, it's unnecessarily resource intensive.
Yeah, it is not a bright solution, and I prefer to use a prepared table of numbers. But since the poster seemed to confused and asked about inlined function, I decided to keep it simple.
I see now that he has come up with a query, but as he refuses to give us sample data to work with, it's difficult to help.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 24, 2013 at 5:58 am
I don't know how to use...your're inline and rcte...function
I only know a little of SQL....
Please tell me more.....thanks
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply