Home Forums SQL Server 2008 SQL Server 2008 - General How to use the subquery column highglighted in the GROUP BY RE: How to use the subquery column highglighted in the GROUP BY

  • December 31, 2013 at 1:55 am

    #1676535

    eobiki10 (12/30/2013)

    Thanks Chris for responding to this query. I have been able to solve the problem.

    EO

    Can you post your solution please? It provides closure for this thread and for those who have taken the time to provide advice, and may help folks who stumble upon it.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden