This look awfully familiar to a recent post. I'll take a look. Thanks.

Recursion can be dangerous but I agree, sometimes very helpful.

Thanks for the script.

What a great idea. I totally agree. Let me see if I can optimize it even more and then force sql to use my version.

I don't view those repetitive tasks as boring.

Ed Wagner (5/15/2015)

---

Thanks. As I'm still on 2008, I don't get to play with LEAD and LAG yet. Looking forward to having one soon, but the hardware hasn't arrived...

Thanks for the question Robert.

I'll never use this but it is still pretty nice.

What this article has done is show me how much index study I need to do. Thanks.

Nice start. Need to fix the minor non-alpha problem.

Good idea. I'll look into it more. Thanks.

Haven't had a need for this yet.

I've yet to use PIVOT for anything. Maybe its my ignorance of its value.

Nice pattern exclusion script. Thanks.

Thanks for the question.