Forum Replies Created

Viewing 15 posts - 1,216 through 1,230 (of 9,698 total)

  • RE: replace null with another column

    MMartin1 (1/10/2017)

    Brandie Tarvin (1/10/2017)

    MMartin1 (1/10/2017)

    drew.allen (1/10/2017)

    MMartin1 (1/9/2017)

    You forgot the NOT.

    SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;

    How about

    SELECT CASE WHEN NULL IS NOT NULL THEN NOT...

    January 10, 2017 at 12:24 pm

    #1921709

  • RE: replace null with another column

    MMartin1 (1/10/2017)

    drew.allen (1/10/2017)

    MMartin1 (1/9/2017)

    You forgot the NOT.

    SELECT CASE WHEN NULL IS NOT NULL THEN NULL ELSE NULL END;

    How about

    SELECT CASE WHEN NULL IS NOT NULL THEN NOT NULL ELSE NULL...

    January 10, 2017 at 12:09 pm

    #1921702

  • RE: Are the posted questions getting worse?

    BrainDonor (1/10/2017)

    jasona.work (1/10/2017)

    My normal 30 minute drive to work took an hour, the roads were crap and slick, and I've got a little rear-wheel drive sporty car.

    Winter tyres. My wife...

    January 10, 2017 at 12:05 pm

    #1921700

  • RE: Are the posted questions getting worse?

    Wow. I haven't talked to any of you guys since last year. Happy New Year, I hope everyone is doing well.

    Quick question(s). Does anyone here hold a CISSP cert?

    The SO...

    January 10, 2017 at 6:54 am

    #1921604

  • RE: Are the posted questions getting worse?

    djj (1/10/2017)

    Thanks all for the words of support. Back today from my gallbladder surgery. Would have been back yesterday but got conflicting information before leaving the hospital and...

    January 10, 2017 at 6:52 am

    #1921603

  • RE: Are the posted questions getting worse?

    rodjkidd (1/9/2017)

    Eirikur and Chris,

    Sorry for the late notice but I only booked today!

    I'm near Oxford Circus tomorrow for a camera flash course. It finishes at 4 30. So could meet...

    January 10, 2017 at 6:51 am

    #1921602

  • RE: Are the posted questions getting worse?

    Michael L John (12/18/2016)

    I left one thing out. I neglected to tell any of the other departments, like support,the names of the new servers.

    That's not leaving something out. That's...

    January 10, 2017 at 6:45 am

    #1921599

  • RE: Are the posted questions getting worse?

    TomThomson (12/17/2016)

    Brandie Tarvin (12/12/2016)

    Gah. Less than a week until my parents visit for two weeks and I catch a cold. The last thing I need to do is give it...

    January 10, 2017 at 6:44 am

    #1921598

  • RE: replace null with another column

    Rasmus Remmer Bielidt (1/5/2017)

    I've had to troubleshoot queries where the developer had forgotten an ELSE clause and the whole thing returned NULL (which was not expected).

    this will yield NULL due...

    January 5, 2017 at 5:08 am

    #1920838

  • RE: replace null with another column

    Rasmus Remmer Bielidt (1/5/2017)

    Brandie Tarvin (1/5/2017)

    Rasmus Remmer Bielidt (1/5/2017)

    Both options have their uses for sure.

    I didn't see anybody making this point, but COALESCE() absolutely needs a non-null argument or it...

    January 5, 2017 at 4:49 am

    #1920833

  • RE: replace null with another column

    Rasmus Remmer Bielidt (1/5/2017)

    Both options have their uses for sure.

    I didn't see anybody making this point, but COALESCE() absolutely needs a non-null argument or it will throw an error where...

    January 5, 2017 at 4:37 am

    #1920829

  • RE: replace null with another column

    drew.allen (1/4/2017)

    CASE is clearly more flexible than COALESCE, because it can perform any conditional test whereas COALESCE only tests whether an expression is NULL, and because it can return any...

    January 5, 2017 at 4:36 am

    #1920828

  • RE: Non-alphanumeric Search Frustration

    Alan.B (1/4/2017)

    Sorry for the off-topic rant; just some food for thought.

    Not at all off topic. You made some very good points. As did Luis about using the functions.

    Thank you both...

    January 5, 2017 at 4:29 am

    #1920826

  • RE: Non-alphanumeric Search Frustration

    Eric M Russell (1/4/2017)

    If the user entered codes are not relationally tied to any other table, then what are the ramifications of them being entered "wrong" ?

    As I said, these...

    January 4, 2017 at 12:50 pm

    #1920744

  • RE: Non-alphanumeric Search Frustration

    Just to clarify. The data is coming from a vendor-created database. I cannot make changes to it. I can, however, send emails to the users saying "Fix this item, it...

    January 4, 2017 at 11:26 am

    #1920716

Viewing 15 posts - 1,216 through 1,230 (of 9,698 total)