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 1 month, 2 weeks ago by  DonlSimpson.
  • 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...
  • 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.

  • Reply To: Complex Join

    Yes, that would be true.

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

  • 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

  • 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

  • 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

  • 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

  • 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

  • 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

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

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

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

  • RE: Today's Random Word!

    Ray K (5/6/2016)


    Ed Wagner (5/6/2016)


    Multiplication

    Division

    Integration

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