Linda 44925 (11/9/2010)
I'm still confused by why the CTE method is better overall?
A CTE is not necessarily better overall. I've seen CTEs that kill performance in certain circumstances. Sometimes it does kick butt over other code, though.
I'm one of those people that prefers to test both methods previous to setting one down in stone in my stored proc. I like to pick the one that works better for my specific databases. You definitely should learn CTEs so you know what you're missing. But they're not the end all, be all of database programming.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.