Home Forums SQL Server 2008 T-SQL (SS2K8) Get list of months, monthname and Year RE: Get list of months, monthname and Year

  • September 2, 2011 at 11:18 pm

    #1376737

    WITH DateYear AS

    (

    SELECT 0 AS num

    UNION ALL

    SELECT num + 1 FROM DateYear

    WHERE num < 11

    )

    SELECT CONVERT(DATE,DATEADD(MONTH,num,'2011')) AS Date from DateYear