Home Forums SQL Server 2008 SQL Server 2008 - General Display ALL rows even if no data exists RE: Display ALL rows even if no data exists

  • August 18, 2014 at 10:28 am

    #1738950

    J Livingston SQL (8/18/2014)

    pwalter83 (8/18/2014)

    sgmunson (8/18/2014)

    Okay, so now the excuse for not explaining EVERYTHING is that some of the columns aren't in use??? Really? Sorry, but I'm done with this. Every explanation I've seen so far has done little or nothing to make this the slightest bit more clear. This person simply can't be bothered, and seems more interested in leading a chase than actually getting useful answers. I'm simply not willing to help someone that insists on playing this game.

    Can you just not reply instead of writing provocatively to discourage others from providing solutions ?

    I, for one, would be happy to consider your problem...but from reading thro this thread...I have to agree that DDL and sample data (and the expected results based on your sample data) would help considerably.

    so far all I see is DDL for two tables (out of six?) and no sample data or expected results.

    I would expect that if you provide what has been requested that your problem can be resolved quickly and with tried and tested code.

    kind regards

    edit typos

    I'm also still in. Paul, can you please provide INSERTs to populate the two tables with say 30 or 40 rows of data? I think it could go a long way to sorting this out. Cheers.

    “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