Forum Replies Created

Viewing 15 posts - 25,981 through 25,995 (of 59,099 total)

  • RE: Calculating age

    hariharannkl (9/7/2013)

    It is very simple, just use the following sql statement,

    (DATEDIFF(YY,DOB,GETDATE()) - CASE

    WHEN MONTH(DOB)<MONTH(GETDATE()) AND (MONTH(DOB)=MONTH(GETDATE()) OR DAY(DOB)>DAY(GETDATE())) THEN 0 ELSE 1

    END)

    Here DOB is Columname, and GETDATE() is...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 7, 2013 at 4:03 pm

    #1648361

  • RE: Calculating age

    math martinez (11/16/2012)

    SO HERE ARE THE QUERY

    DECLARE @DOB SMALLDATETIME

    SELECT @DOB = '11/15/1987'

    SELECT

    CASE

    WHEN MONTH(@DOB) >= MONTH(GETDATE()) AND DAY(@DOB) >=DAY(GETDATE()) THEN DATEDIFF(YY,@DOB,GETDATE())

    ELSE DATEDIFF(YY,@DOB,GETDATE())-1

    END AS AGE

    HOPE I CAN HELP! 🙂

    It...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 7, 2013 at 3:59 pm

    #1648359

  • RE: Calculating age

    If you believe that people that were born on the last day of February on a leap year turn a year older on the last day of February on non-leap...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 7, 2013 at 3:52 pm

    #1648357

  • RE: Calculating age

    Garadin (1/10/2009)

    DECLARE @DOB datetime

    SET @DOB = '1/20/1980'

    SELECT CASE

    WHEN DATEPART(DY,GETDATE()) >= DATEPART(DY,@DOB)

    THEN DATEDIFF(YY,@DOB,GETDATE())

    ELSE DATEDIFF(YY,@DOB,GETDATE())-1

    END

    Oh, be careful now. I know this is an old post but the code above doesn't...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 7, 2013 at 3:29 pm

    #1648353

  • RE: Dazed and Confused

    What is the datatype for Z.ExpYear and YD.Year?

    Also, since you're relatively new to these forums, see the first "Helpful Link" in my signature line below for how to get better...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 7, 2013 at 3:16 pm

    #1648351

  • RE: Path to a Database Architect

    C.K.Shaiju (9/4/2013)

    Hi Guys,

    Would you please provide some links or books details to learn to become Database Architect.

    Sure... best link for this type of thing in the world.

    http://bit.ly/13tl6t8

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 7, 2013 at 3:04 pm

    #1648350

  • RE: Tally Tables

    Hugo Kornelis (9/6/2013)

    Hi Jeff! 🙂

    Jeff Moden (9/6/2013)

    First and semantically speaking, using ROW_NUMBER() isn't the same as an actually Tally Table.

    I completely agree with this....

    Second, if you don't think the "physical"...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 7, 2013 at 11:49 am

    #1648339

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/6/2013)

    Steve Jones - SSC Editor (9/6/2013)

    Jeff Moden (9/5/2013)

    Steve Jones - SSC Editor (9/5/2013)

    http://www.liveleak.com/view?i=424_1378224156

    Let's stick Jeff in this interview 😉

    BWAAA-HAAAA!!!! Don't forget... I take porkchops to interviews, as well....

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 6, 2013 at 9:22 am

    #1648135

  • RE: change the default database

    Mark, meet Sean. Sean, meet mark. 🙂

    Mark... you're on. 🙂

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 6, 2013 at 9:12 am

    #1648131

  • RE: Forum Etiquette: How to post data/code on a forum to get the best help

    gitmo (9/6/2013)

    I go to this thread more than any other. There is not only good information on posting to forums, but I find the techniques in here useful in...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 6, 2013 at 9:09 am

    #1648128

  • RE: Forum Etiquette: How to post data/code on a forum to get the best help

    Sean Lange (9/6/2013)

    Jeff one other thing that might make an excellent addition to this article is an explanation of how to collect the information. There are many times that people...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 6, 2013 at 9:08 am

    #1648127

  • RE: Tally Tables

    sknox (9/3/2013)

    ]

    See the problem? They imply that a tally table has to be intrinsically ordered -- this is simply untrue. A tally table simply has to be orderable.

    So even...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 6, 2013 at 6:33 am

    #1648037

  • RE: Export with Headers

    Damn. I forgot all about this. I'll get started early next week. According to what Steve asked for in his OP, I'm thinking that I might be...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 5, 2013 at 8:06 pm

    #1647909

  • RE: change the default database

    In that case, I think Mark should write it and Sean, being a new member of the 10K club, should review it and help guide Mark to his first "Spackle"...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 5, 2013 at 7:56 pm

    #1647907

  • RE: Forum Etiquette: How to post data/code on a forum to get the best help

    Based on people's fine suggestions over the last 6 years, there are some things I need to add to this article. Since I'm great as misplacing things, here's the...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

    September 5, 2013 at 7:29 pm

    #1647902

Viewing 15 posts - 25,981 through 25,995 (of 59,099 total)