Forum Replies Created

Viewing 15 posts - 1,246 through 1,260 (of 9,707 total)

  • RE: replace null with another column

    Or use a CASE statement.

    SELECT Col1, Col2,

    CASE WHEN cte1.Col IS NULL THEN cte2.Col ELSE cte1.Col END AS MyCol

    FROM ....

    This assumes that you can join the CTEs to each other...

  • RE: Are the posted questions getting worse?

    Siiiiiigggggghhhhh.

    You would think when I get an alert that a log file drive is full in a non-prod system the first thing I would look at is whether or not...

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (12/16/2016)


    Phil Parkin (12/16/2016)


    Grumpy DBA (12/16/2016)


    Wow, today's spam includes a warning about BOOTY POP... dang, just as I was about to order cases of BOOTY POP for my family...

  • RE: Are the posted questions getting worse?

    Beware the Twitter list. For it is a way of defining you and boxing you into a corner!

    Actually, lists can be followed as a whole (I don't remember how) so...

  • RE: Are the posted questions getting worse?

    JustMarie (12/13/2016)


    drew.allen (12/13/2016)


    Does any else think that this response borders on being unethical? http://www.sqlservercentral.com/Forums/FindPost1842475.aspx It sounds like she wants to use this approach just to avoid due...

  • RE: Are the posted questions getting worse?

    Beatrix Kiddo (12/12/2016)


    Do you have Vick's First Defence (First Defense ;-)) nasal spray over there? I find it quite good- not sure how scientific it is, but my theory is...

  • RE: Are the posted questions getting worse?

    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 to them because...

  • RE: Are the posted questions getting worse?

    rodjkidd (12/9/2016)


    ChrisM@Work (12/8/2016)


    rodjkidd (12/7/2016)


    Eirikur,

    I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?

    Chris, are you about?

    Rodders...

    Oh poo....

  • RE: Today's Random Word!

    Stuart Davies (12/8/2016)


    Ray K (12/7/2016)


    whereisSQL? (12/7/2016)


    Manic Star (12/7/2016)


    Ed Wagner (12/7/2016)


    djj (12/7/2016)


    Luis Cazares (12/7/2016)


    Ed Wagner (12/7/2016)


    DamianC (12/7/2016)


    Revenant (12/7/2016)


    Manic Star (12/7/2016)


    Limbo

    Stick

    Man

    Machine

    War

    Materials

    Labor

    Delivery

    Midwife

    Midtown

    Midriff

    Bare

  • RE: Today's Random Word!

    Ed Wagner (12/7/2016)


    crookj (12/7/2016)


    Ed Wagner (12/7/2016)


    djj (12/7/2016)


    Ed Wagner (12/6/2016)


    Manic Star (12/6/2016)


    whereisSQL? (12/6/2016)


    Revenant (12/6/2016)


    Iceland

    IceCream

    Vanilla

    Sugar

    Brown

    Molasses

    Flood (of 1919)

    Browning (first thing I think of when I see 1919)

    Rifle

  • RE: Are the posted questions getting worse?

    Sean Lange (12/6/2016)


    Time for the annual voyage to a destination for my wife's holiday party. They really go all out!!! They always fly the employees to a location and pay...

  • RE: Today's Random Word!

    djj (12/6/2016)


    Ed Wagner (12/6/2016)


    Manic Star (12/6/2016)


    djj (12/6/2016)


    Brandie Tarvin (12/6/2016)


    Kaye Cahs (12/6/2016)


    Grumpy DBA (12/6/2016)


    Ed Wagner (12/6/2016)


    Cream

    Cookies

    Milk

    Santa

    Baby

    Buggy

    Walk

    Amble

    Meander

  • RE: Today's Random Word!

    Kaye Cahs (12/6/2016)


    Grumpy DBA (12/6/2016)


    Ed Wagner (12/6/2016)


    Cream

    Cookies

    Milk

    Santa

  • RE: Error updating SQL Server with CU pack

    I broached this issue to my coworkers. Turns out the system account owned all the folders in question, not allowing us to make changes to them via the install package,...

  • RE: Today's Random Word!

    There will be A TEST!

    😀

Viewing 15 posts - 1,246 through 1,260 (of 9,707 total)