• CELKO:

    1) Take yous ISO elsewhere. This is a SQL Server specific forum and at least 97.4% of the people here couldn't care less. BTW, I'm being generous giving you 2.6%.

    2) Was there a single thing you said in your first diatribe that would actually help the OP? Wait, pretend i didn't ask the question. It was completely rhetorical. No one here wants to hear any response from you on that one - we already know the answer.

    3) Regarding the RIDICULOUS statement about CROSS APPLY and performance, go do some research on Adam Machanic and the INCREDIBLE performance and scale he gets on massive data warehouse queries using that construct.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service