Sean Lange (3/18/2013)
Yes I don't think there is a clear cut advantage for either approach as far as performance is concerned. I think it boils down to preference.
If you come back to where it's started you'll see it's exactly what I said.
The only difference is as minor as an extra line of code required for syntax sake only.
I'm not so sure about that "in-memory" thing, therefore I did not bring it up, until you guys forced me. 🙂
But I know there is controversy around it.
That's why I prefer (and suggest) not to use CTE where it's not necessary.
Again, it's my preference.
_____________
Code for TallyGenerator