Forum Replies Created

Viewing 15 posts - 151 through 165 (of 667 total)

  • RE: Are the posted questions getting worse?

    RBAR

    CTE

    rCTE

    Edit: Added two more.

    --------------------------------------------------------------------------
    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]

    November 6, 2012 at 6:32 am

    #1556430

  • RE: Talking baseball

    Tigers or Giants, doesn't really matter to me who wins. May it be a great series!

    BTW, I still haven't understood why it is called the "World Series", if only North...

    --------------------------------------------------------------------------
    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]

    October 23, 2012 at 10:10 am

    #1552004

  • RE: Char And int

    Nice one, Tom! But does the TRY_CONVERT() make the query non-sargeable? Guess it 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]

    October 15, 2012 at 9:38 am

    #1549177

  • RE: Char And int

    May I ask why are you storing an integer as an nvarchar?

    --------------------------------------------------------------------------
    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]

    October 10, 2012 at 5:16 am

    #1547596

  • RE: APPLY - 2

    Grrrr!!! Seems I can't count properly on a Monday morning.

    Good question though, Ron!

    --------------------------------------------------------------------------
    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]

    October 1, 2012 at 4:41 am

    #1543910

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/6/2012)

    Stefan Krzywicki (9/6/2012)

    Lynn Pettis (9/6/2012)

    jcrawf02 (9/6/2012)

    SQLRNNR (9/6/2012)

    Lynn Pettis (9/6/2012)

    SQLRNNR (9/6/2012)

    Lynn Pettis (9/6/2012)

    Why do people think that they will get a different answer to the same problem if they post...

    --------------------------------------------------------------------------
    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]

    September 6, 2012 at 3:48 pm

    #1534782

  • RE: Are the posted questions getting worse?

    RBarryYoung (9/6/2012)

    Stefan Krzywicki (9/5/2012)

    Fal (9/3/2012)

    Quick poll: how would you pronounce the word "Route"?

    I'll explain why later, if I'm not too embarrassed. :blink:

    Steve.

    "Root" is the proper pronunciation as Nat King...

    --------------------------------------------------------------------------
    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]

    September 6, 2012 at 10:48 am

    #1534634

  • RE: ISDATE

    Just a question: Why would one want to pass a DATE to ISDATE()? Surely that should always return TRUE, even if it is NULL (which it doesn't if passed a...

    --------------------------------------------------------------------------
    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]

    August 28, 2012 at 4:04 am

    #1530666

  • RE: Are the posted questions getting worse?

    venoym (8/14/2012)

    ...and we're now dealing with ICD9 to ICD10 conversion, ...

    You are only now converting to ICD10? Those have been mandatory in South Africa (where I live) for the last...

    --------------------------------------------------------------------------
    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]

    August 14, 2012 at 1:48 pm

    #1525769

  • RE: Express Edition

    Liked that question, but had to scratch through BOL for a while to get it right, just because I haven't used the Express editions. I'm lucky to get to use...

    --------------------------------------------------------------------------
    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]

    August 13, 2012 at 4:07 pm

    #1525320

  • RE: Are the posted questions getting worse?

    WayneS (8/12/2012)

    For those that enjoy this sort of thing, here is a pretty good comparison of the various running totals methods available.

    http://www.sqlperformance.com/2012/07/t-sql-queries/running-totals

    I did. Reminds me of looking up again when...

    --------------------------------------------------------------------------
    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]

    August 12, 2012 at 1:19 pm

    #1524871

  • RE: Talking baseball

    Just back from our second winter practice. Feels great! If it wasn't for the first injury of the season by one of the first team players (badly hurt his left...

    --------------------------------------------------------------------------
    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]

    August 12, 2012 at 9:09 am

    #1524849

  • RE: Are the posted questions getting worse?

    L' Eomot Inversé (8/11/2012)

    Jan Van der Eecken (8/11/2012)

    Coming back to the picture that was pulled due to being politically inacceptable. Could whoever posted it there please send me a PM...

    --------------------------------------------------------------------------
    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]

    August 11, 2012 at 10:20 am

    #1524787

  • RE: Are the posted questions getting worse?

    Coming back to the picture that was pulled due to being politically inacceptable. Could whoever posted it there please send me a PM with the link to the original one?...

    --------------------------------------------------------------------------
    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]

    August 11, 2012 at 5:13 am

    #1524771

  • RE: Are the posted questions getting worse?

    Jeff Moden (8/10/2012)

    ...what would you use for a key that truly prevented such problems as those which arise in a merger?

    We ran into that exact problem when our company in...

    --------------------------------------------------------------------------
    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]

    August 11, 2012 at 5:02 am

    #1524768

Viewing 15 posts - 151 through 165 (of 667 total)