• 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