[Responding to: kevonh]

Nothing wrong with your approach, specifically. But this thread is about an article posted here:

http://www.sqlservercentral.com/articles/Stored+Procedures/72623/

And in the first paragraph, the article's author states that s/he...

Interesting article and all. But I hope I'm never in a situation to need this. I've always had employers and clients that have stored proc scripts (plus many...

Just a suggestion, seemingly might help with performance as this would get rid of that CTE. Anyhow, here's how I would do it...

Create a table (perm, temp, or variable...

Wow, if this truly is a homework assignment, and the poster has no experience in relational databases, as seemingly is the case… then that’s going to be one heck...

Sorry for the criticism, but I find this article very poorly written. There is no information given why I would want to like into this code, what purpose it...