Home Forums SQL Server 2005 T-SQL (SS2K5) first official day of every month for past 3 years RE: first official day of every month for past 3 years

  • October 15, 2012 at 6:54 am

    #1549112

    No much details isn't it.

    So very generic answer:

    SELECT YEAR(YourDateColumn)

    ,DATENAME(MONTH,MONTH(YourDateColumn)

    ,MIN(YourDateColumn) AS [first run date in this month]

    FROM [YourTable]

    WHERE YourDateColumn >= DATEADD(YEAR,-2,GETDATE())

    GROUP BY YEAR(YourDateColumn), MONTH(YourDateColumn)

    ORDER BY YEAR(YourDateColumn), MONTH(YourDateColumn)

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]