Forum Replies Created

Viewing 15 posts - 1 through 15 (of 416 total)

  • Reply To: Complex Join

    At least I know it's not something trivial that I overlooked.  🙂

    • This reply was modified 3 years, 9 months ago by  DonlSimpson.

    September 9, 2020 at 5:47 pm

    #3787383

  • Reply To: Complex Join 

    /*
    drop table leftTable;
    drop table rightTable;
    */
    create table leftTable (C1 int, C2 int, C3 varchar(20));
    create table rightTable (C1 int, C2 int, C3 varchar(20));

    insert into leftTable values (1, 1, 'leftTable...

    September 8, 2020 at 8:26 pm

    #3787121

  • Reply To: Complex Join

    It's not what is expected, and the data condition won't occur.  Each column is null-able, but both cannot be null.

    September 5, 2020 at 6:31 pm

    #3786608

  • Reply To: Complex Join

    Yes, that would be true.

    September 4, 2020 at 11:15 pm

    #3786521

  • Reply To: Complex Join

    Unfortunately, either column can be null in one table and not null in the other.  When I said "related by," I didn't mean to imply that there's an FK relationship. ...

    September 4, 2020 at 9:04 pm

    #3786495

  • RE: Today's Random Word!

    crookj (5/17/2016)

    djj (5/17/2016)

    Ed Wagner (5/17/2016)

    ThomasRushton (5/17/2016)

    Ed Wagner (5/17/2016)

    BWFC (5/17/2016)

    Ed Wagner (5/17/2016)

    Alan.B (5/16/2016)

    Manic Star (5/16/2016)

    crookj (5/16/2016)

    Hugo Kornelis (5/16/2016)

    Revenant (5/16/2016)

    HappyGeek (5/16/2016)

    Grumpy DBA (5/16/2016)

    djj (5/16/2016)

    Penalty

    Shot

    Goal

    Stretch

    Limo

    Limbo

    Chiropractor

    Bill

    Gates

    Pearly

    Whites

    Yolks

    Emulsifier

    Blend

    Amalgam

    Filling

    May 17, 2016 at 9:28 am

    #1879568

  • RE: Today's Random Word!

    whereisSQL? (5/16/2016)

    djj (5/16/2016)

    Ray K (5/16/2016)

    crookj (5/16/2016)

    Ed Wagner (5/16/2016)

    Grumpy DBA (5/16/2016)

    Ed Wagner (5/16/2016)

    djj (5/16/2016)

    Fork

    Road

    (less) Traveled

    Scholar

    Intellectual

    Academic

    Academy

    Award

    Points

    May 16, 2016 at 9:27 am

    #1879297

  • RE: Today's Random Word!

    djj (5/13/2016)

    Ed Wagner (5/13/2016)

    Ray K (5/13/2016)

    Grumpy DBA (5/13/2016)

    ThomasRushton (5/13/2016)

    Mechanic

    Mike (and the Mechanics... a bit of a stretch)

    Rutherford (I liked Mike + The Mechanics!)

    Race

    Arms

    Legs

    May 13, 2016 at 11:52 am

    #1878996

  • RE: Today's Random Word!

    Ed Wagner (5/12/2016)

    djj (5/12/2016)

    Revenant (5/12/2016)

    Ed Wagner (5/12/2016)

    yb751 (5/12/2016)

    Luis Cazares (5/12/2016)

    crookj (5/12/2016)

    ThomasRushton (5/12/2016)

    Ed Wagner (5/12/2016)

    Grumpy DBA (5/12/2016)

    whereisSQL? (5/11/2016)

    Ed Wagner (5/11/2016)

    Hogwarts

    Dementor

    Azkaban

    Sirius Black

    Dog star

    Lassie

    Rin Tin Tin

    German Shepherd

    Bichon Frise

    Cute

    Kitten

    The Expert (https://www.youtube.com/watch?v=BKorP55Aqvg) :-D:-D:-D

    Engineer

    May 12, 2016 at 2:42 pm

    #1878781

  • RE: Today's Random Word!

    Ed Wagner (5/11/2016)

    Hugo Kornelis (5/11/2016)

    Grumpy DBA (5/11/2016)

    djj (5/11/2016)

    Fried

    Brain

    Dead

    Quick

    Fox

    May 11, 2016 at 12:02 pm

    #1878354

  • RE: Today's Random Word!

    crookj (5/9/2016)

    Eric M Russell (5/9/2016)

    whereisSQL? (5/6/2016)

    Ed Wagner (5/6/2016)

    Eric M Russell (5/6/2016)

    djj (5/6/2016)

    Grumpy DBA (5/6/2016)

    ZZartin (5/6/2016)

    Ed Wagner (5/6/2016)

    Steal

    Plunder

    Pirate

    Ship

    Cruise

    Missile

    Launch

    Haunch

    Hunkers

    Huddle

    May 9, 2016 at 8:37 am

    #1877498

  • RE: Padding a string with extra 0's

    tarr94 (5/6/2016)

    Thank you for the responses! I'll give this a try. Looks like the solution might have been simpler than I had expected.

    I've updated my original post to...

    May 6, 2016 at 5:24 pm

    #1877291

  • RE: Padding a string with extra 0's

    Jacob Wilkins (5/6/2016)

    This is the sort of thing I would avoid doing at the database layer if possible

    +1

    Definitely agree.

    May 6, 2016 at 2:31 pm

    #1877275

  • RE: Padding a string with extra 0's

    tarr94 (5/6/2016)

    Hello,

    I'll start with my sample table data.

    ...

    I'm trying to figure out how I can retrieve a string that concatenates the OrderNumber, PurchaseDate, and CustomerNumber into one string....

    May 6, 2016 at 2:29 pm

    #1877273

  • RE: Today's Random Word!

    Ray K (5/6/2016)

    Ed Wagner (5/6/2016)

    Multiplication

    Division

    Integration

    May 6, 2016 at 2:14 pm

    #1877269

Viewing 15 posts - 1 through 15 (of 416 total)