Forum Replies Created

Viewing 15 posts - 2,101 through 2,115 (of 2,443 total)

  • RE: Calculating Age

    Richard Briggs (3/13/2009)


    Comrades,

    Around one's birthday, we can be 16 in the UK, but still 15 in the US.

    Worth mentioning as may be relevant to certain age verification web applications.

    Brigzy

    16:36 UK...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Jack Corbett (3/13/2009)


    Steve,

    I like the New Link button in the toolbar. It makes including a link as a link much easier. Was that just added today or have...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Calculating Age

    jpratt (3/13/2009)


    This was perfect timing, Lynn, since I need to produce an Age column in a view for patients in our medical facility. Since I only need to know...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Calculating Age

    Andrew (3/13/2009)


    how many DOB fields have you seen that include a complete timestamp down to the seconds? I'm sure there might be some in the medical field, but beyond that...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: "Answered" Posts

    Michael Valentine Jones (3/12/2009)


    I made that last post to try to see why my prior post was not showing on my Recent Posts display.

    Neither showed up, so I am not...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Random 64 Characters alphanumeric String

    AFIFM (3/11/2009)


    I need to create a random 64 alphanumeric string every time a new row is added to a SQL 2005 database table. It does not have to be unique.

    What...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Bob, gotta ask, what is your avatar supposed to be?

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Why INSER INTO ... UNION ALL?

    Mohit (3/10/2009)


    And most of my developer buddies hate UNION ALL because they find it it makes it hard to read.

    I never understand that part, I know some of...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Edit:

    Alvin Ramard (3/11/2009)


    Roy,

    Given

    that it's Arkansas,

    nobody will expect you to understand Arkansian

    .

    😀

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Conversion Fun

    J (3/11/2009)


    OKay ...

    Yes I did learn something here, about a star symbol being entered by an implicit conversion. All the more reason to condemn "tricks" like assigning an integer to...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    geez guys, take it easy! I'm trying to eat some Chinese here, and sucked down a whole lungful of rice laughing at "well oil beef honked"

    Phew . . .

    :hehe:

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: XML Manipulation Problem

    See this article for Tally Table information:

    http://www.sqlservercentral.com/articles/TSQL/62867/

    🙂

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Conversion Fun

    SanjayAttray (2/12/2009)


    This question is mentioned for March 11 and today is feb 12.

    Now that's funny. Here it is March 11th, and it pops up again. sp_MSGoBackInTime really does work.

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Union Benefits

    Steve Jones - Editor (3/10/2009)


    That's what meetings should be for sure. and they should be short. too many people schedule an hour when 10 minutes would work.

    Amen, brother, preach it!...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (3/9/2009)


    The only that I ever had problems with group by is when the group bys and the select didn't match perfectly, IE case when in the select, then put...

    ---------------------------------------------------------
    How best to post your question[/url]
    How to post performance problems[/url]
    Tally Table:What it is and how it replaces a loop[/url]

    "stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."

Viewing 15 posts - 2,101 through 2,115 (of 2,443 total)