Forum Replies Created

Viewing 15 posts - 2,266 through 2,280 (of 2,443 total)

  • RE: Is there a function which determines if a varchar is a number?

    Lowell (11/3/2008)


    you can try the isnumeric function:

    WHERE ISNUMERIC(SOMEVARCHAR) = 1

    but as others will tell you, it's not 100% reliable, because of the way it is structured; for exampel

    select isnumeric('1E2')

    select...

  • RE: Life is Like a Manure Spreader

    Politician AND a manure spreader - http://www.tomlynch4supervisor.com-a.googlepages.com/pastisprologue

    By the way, what's the second half of the title?

    "Life is like a manure spreader" . . .

    . . . If you're not...

  • RE: 'N' number of usage - Tally Table

    rbarryyoung (10/26/2008)


    rbarryyoung (10/9/2008)


    Jeff Moden (10/9/2008)


    True enough... but have you ever see it used for anything other than a delimiter? 🙂

    I've seen it used for emoticons-> :Þ

    Jeff Moden (10/9/2008)


    Heh... I...

  • RE: How to.....

    ggraber (10/27/2008)


    Jack Corbett (10/26/2008)


    Fraggle (10/26/2008)


    However, to my knowledge, SQL Saturday are Florida only.

    Actually SQLSaturday is NOT a Florida only thing. There have been SQLSaturday's in Washington state,...

  • RE: Barriers to Entry, Database Weekly (Oct 27 2008)

    ChrisPapps (10/26/2008)


    I saw a signature on a forum (apologies to the person involved, I cannot remember where or when) but it could serve as a particularly cute candidate shibboleth for...

  • RE: Barriers to Entry, Database Weekly (Oct 27 2008)

    Stephanie J Brown (10/26/2008)


    Plus I find that often when I have an issue on my "event horizon", and answer or direction appears in the newsletter - so apparently I...

  • RE: Who Wants to Be Rich?

    John Rowan (10/21/2008)


    Well, first of all, everyone's opinion of rich differs. Making 150 K per year is far from rich. I do know that there are a couple...

  • RE: Who Wants to Be Rich?

    Andy Warren (10/20/2008)


    No one going to pick on the violinist? Hard not to understand his point, but no points for gracefully accepting a little adulation.

    lol good point, but what do...

  • RE: Who Wants to Be Rich?

    K. Brian Kelley (10/20/2008)


    This link puts into perspective that sudden wealth isn't the answer. The problems which existed beforehand are still present and a whole host of new problems will...

  • RE: SQL library - best practices

    Eric Klovning (10/19/2008)


    We use an approach similar to the following:

    http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62933/

    From a technical standpoint it works well as a script distribution mechanism but I doubt we have realized much in...

  • RE: Variable #of arguments to UDF/stored procedure

    Not sure if this is going to be extremely helpful, but it might reduce your dataset a little. Rather than listing 401.1,401.2,401.3, etc as hypertension, just look at the...

  • RE: Help needed with a CASE

    MrBaseball34 (10/15/2008)


    jcrawf02 (10/15/2008)


    Can you de-identify the data to meet HIPAA reqs? John/Jane Doe and scramble the id numbers or something?

    I will try but there are 340,000 ptEncounter records, 610,000 ptDictation...

  • RE: Too Good at Data Analysis

    GSquared (10/15/2008)


    Matt Miller (10/14/2008)


    Let's not forget one of the biggest factors the various models forget to deal with...the power the model itself wields on the underlying system it was designed...

  • RE: Help needed with a CASE

    Can you de-identify the data to meet HIPAA reqs? John/Jane Doe and scramble the id numbers or something?

  • RE: Too Good at Data Analysis

    jpowers (10/15/2008)


    Steve Jones - Editor (10/15/2008)


    I'm not sure there was a lot of forcing loans. There have been numerous interviews from lots of brokers that were making upwards of $50k...

Viewing 15 posts - 2,266 through 2,280 (of 2,443 total)