Forum Replies Created

Viewing 15 posts - 181 through 195 (of 667 total)

  • RE: Are the posted questions getting worse?

    Guess that'll only happen once it is deprecated and was really purged out of the product. Which didn't happen in 2012 although I kind of expected it. At least the...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 12, 2012 at 10:50 am

    #1512186

  • RE: Are the posted questions getting worse?

    Lynn Pettis (7/12/2012)

    Jan Van der Eecken (7/12/2012)

    I like this reply to JC

    Your link does work because of the " around the URL.

    http://www.sqlservercentral.com/Forums/FindPost1328989.aspx

    I noticed. Fixed now.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 12, 2012 at 10:42 am

    #1512182

  • RE: Are the posted questions getting worse?

    I like this reply to JC

    Edit: Fixed the URL.

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 12, 2012 at 10:40 am

    #1512178

  • RE: Please help me with this query

    I presume this was just an example to illustrate your point, but overall, what was it you were trying to do? Get the top 3 Custumors' IDs, ordered by CustumorID...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 12, 2012 at 7:30 am

    #1512047

  • RE: update statment help

    You beat me to is Luis

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 12, 2012 at 7:21 am

    #1512043

  • RE: Are the posted questions getting worse?

    Magnificent, Gail! Have a good party tonight!

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    July 4, 2012 at 7:37 am

    #1508775

  • RE: COALESCE

    CELKO (6/25/2012)

    Jan Van der Eecken (6/25/2012)

    Unless they coded ISNULL(a,b) as a wrapper around COALESCE(x1,x2,...,xn), which I would probably have done, just from a maintainability point of view. Then ISNULL should...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 26, 2012 at 4:23 am

    #1505475

  • RE: COALESCE

    Unless they coded ISNULL(a,b) as a wrapper around COALESCE(x1,x2,...,xn), which I would probably have done, just from a maintainability point of view. Then ISNULL should actually be slower due to...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 25, 2012 at 6:35 pm

    #1505341

  • RE: COALESCE

    GSquared (6/25/2012)

    Nah. It's a perfectly good question.

    Another thing to keep in mind about IsNull vs Coalesce is that Coalesce is ISO-standard SQL, and has some slight advantages because of...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 25, 2012 at 6:17 pm

    #1505337

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (6/25/2012)

    0-1 column instead of BIT.

    Don't take the word BIT in your mouth. JC is watching!

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 25, 2012 at 5:51 pm

    #1505332

  • RE: TVP Physical Order

    Just think about it.

    You go to a grocery market and see this nice bucket of tomatoes (they are like in a heap) and say "I want them all". So the...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 24, 2012 at 5:03 pm

    #1504855

  • RE: COALESCE

    COALESCE allows an unlimited number of parameters and returns the value of the first expression, evaluated from left to right, that is not NULL.

    See BOL on MSDN

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 24, 2012 at 4:23 pm

    #1504853

  • RE: clearing tempDB

    GilaMonster (6/24/2012)

    SQL will automatically drop temp tables as soon as they go out of scope...

    I totally agree with Gail (who doesn't), but the assumption is that they, the temp tables...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 24, 2012 at 12:30 pm

    #1504841

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (6/20/2012)

    Life has suddenly changed. Our daughter is in hospital and very unlikely to come out again. We originally thought it was something that that would...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 24, 2012 at 12:11 pm

    #1504838

  • RE: Delete Trigger

    Evil Kraig F (6/18/2012)

    Jan Van der Eecken (6/18/2012)

    Evil Kraig F (6/18/2012)

    Jan Van der Eecken (6/18/2012)

    Oops, I misspelled your name. Apologies, Kraig!

    LOL, at this point, either is acceptable. 😉 :w00t:...

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

    June 18, 2012 at 5:44 pm

    #1502524

Viewing 15 posts - 181 through 195 (of 667 total)