Forum Replies Created

Viewing 15 posts - 106 through 120 (of 541 total)

  • RE: Display ALL rows even if no data exists

    ChrisM@Work (8/26/2014)

    pwalter83 (8/25/2014)

    ChrisM@Work (8/20/2014)

    Paul, if you wouldn't mind running through your sample script and correcting the errors which Steve kindly pointed out, I'll take a look later today.

    Hi Chris,

    The sample...

    August 26, 2014 at 9:32 am

    #1741056

  • RE: Display ALL rows even if no data exists

    David Burrows (8/26/2014)

    SELECTa.BOOKING_NUM,

    d.COUNTRY_DSC,

    CASE WHEN POL_LOCATION_CD IN ('DKAAR', 'DKCPH', 'FIHEL','FIKTK', 'IEORK', 'IEDUB', 'NLRTM', 'PTLEI', 'PTOPO', 'PTLIS', 'ESBIO', 'ESVGO', 'SEGOT', 'SEHEL', 'GBBEL') THEN 'NLRTM' WHEN POL_LOCATION_CD IN ('DKFRC',

    'FIRAU', 'FIOUL', 'DEBRV',...

    August 26, 2014 at 8:33 am

    #1741035

  • RE: Display ALL rows even if no data exists

    ChrisM@Work (8/20/2014)

    Paul, if you wouldn't mind running through your sample script and correcting the errors which Steve kindly pointed out, I'll take a look later today.

    Hi Chris,

    The sample script is...

    August 25, 2014 at 7:19 am

    #1740698

  • RE: Display ALL rows even if no data exists

    sgmunson (8/19/2014)

    I'm pretty sure I can't force anyone to do anything. I don't need to. Clearly, you'd rather complain than actually solve your problem. ...

    August 19, 2014 at 9:36 am

    #1739273

  • RE: Display ALL rows even if no data exists

    sgmunson (8/19/2014)

    Just a quick FYI to make everyone aware that the posted query doesn't work with the posted table inserts, and that you'll need to add a right paren to...

    August 19, 2014 at 9:12 am

    #1739262

  • RE: Display ALL rows even if no data exists

    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...

    August 19, 2014 at 8:39 am

    #1739242

  • RE: Display ALL rows even if no data exists

    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....

    August 18, 2014 at 9:55 am

    #1738927

  • RE: Display ALL rows even if no data exists

    ChrisM@Work (8/18/2014)

    I know what you are attempting to do here and it wouldn't take long with access to your tables, however scripts for all of the tables along with sample...

    August 18, 2014 at 9:04 am

    #1738898

  • RE: Display ALL rows even if no data exists

    sgmunson (8/18/2014)

    I still don't have any indication as to the results of the GROUP BY query I submitted. If you didn't run it because it uses a CTE,...

    August 18, 2014 at 8:31 am

    #1738881

  • RE: Display ALL rows even if no data exists

    ChrisM@Work (8/18/2014)

    Hi Paul

    Can you provide the following please?

    CREATE TABLE for MG_COUNTRY with INSERTs to populate a few sample rows

    Do you wish to include every row from this table in the...

    August 18, 2014 at 5:26 am

    #1738793

  • RE: Display ALL rows even if no data exists

    ChrisM@Work (8/15/2014)

    Thanks Steve. Something along these lines then. Not sure where two of the tables (MG_COUNTRY,MG_OFFICE) fit into this but it's worth a try:

    Thanks for your code, Chris. However, it...

    August 18, 2014 at 2:24 am

    #1738732

  • RE: Display ALL rows even if no data exists

    sgmunson (8/14/2014)

    Okay, I got to it sooner. Try this:

    Thanks again Steve for taking time out of your work.

    I am not getting the desired result with your modified query....

    August 14, 2014 at 8:24 am

    #1738062

  • RE: Display ALL rows even if no data exists

    sgmunson (8/13/2014)

    I fail to understand what the discomfort level is with CTEs. It's kind of like having a subquery, but just that it appears BEFORE the rest of the...

    August 14, 2014 at 2:38 am

    #1737946

  • RE: Display ALL rows even if no data exists

    blank

    August 14, 2014 at 2:29 am

    #1737942

  • RE: Display ALL rows even if no data exists

    ChrisM@home (8/8/2014)

    pwalter83 (8/8/2014)

    ChrisM@Work (8/7/2014)

    I don't see any parameters in your code, Paul.

    Any ideas, Chris ??[/quote

    Hi Paul, I'm on break in Normandy with no access to SQL Server until tuesday. A...

    August 13, 2014 at 9:46 am

    #1737668

Viewing 15 posts - 106 through 120 (of 541 total)