Home Forums SQL Server 7,2000 T-SQL 3 month data count comparison RE: 3 month data count comparison

  • September 5, 2014 at 3:06 pm

    #1743625

    khott (8/18/2014)

    Hello all,

    So I am trying to figure out a way to present the number of records for a 3 month window and for the same date. I know not all months have 31 days so it would need to be smart enough so it does not error out. This is kinda the manual way to help you understand what I am looking for:

    select count(learner_id) TheCount, month(creation_date) TheMonth from learner_info

    where creation_date between '8/1/2014' and '8/18/2014'

    or creation_date between '7/1/2014' and '7/18/2014'

    or creation_date between '6/1/2014' and '6/18/2014'

    group by month(creation_Date)

    Keep in mind, tomorrow all three dates will need to be the 19th and the next day the 20th and so on.

    Thank you in advance.

    Kam

    I don't know if your creation_date column has times in it but remember that BETWEEN is INCLUSIVE of both end points.

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