Home Forums SQL Server 2008 SQL Server Newbies Header and details query RE: Header and details query

  • September 10, 2015 at 2:41 am

    #1825616

    Edvard Korsbæk (9/10/2015)

    It will take me app. 15 minutes to create a program, that makes the report - OK

    So, I use the Jack as you descibe it.

    I am in the 'Newbies' section - And trying to understand what i can get from SQL 'Native'

    This was one, which I understand is a 'not'.

    So, thanks!

    Best regards

    Edvard Korsbæk

    You're welcome, and thanks for the feedback. Post back if you have any uncertainty about how to proceed with this.

    “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