select the last month in SQL server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » select the last month in SQL server 2005

11 posts, Page 2 of 2

««1 2

select the last month in SQL server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

Mitesh Oswal

Posted Monday, December 14, 2009 5:49 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, February 15, 2013 1:56 AM
Points: 593, Visits: 371

DECLARE @year VARCHAR(10)

SELECT @year = '2009'

SELECT
LEFT(CONVERT(VARCHAR,DATEADD(MM,number,@year),112),4)+' '+ LEFT(DATENAME(MM,DATEADD(MM,number,@year)),3)
FROM
Master..spt_Values
WHERE
Type = 'p' AND

number < DATEPART(MM,GETDATE())-1

Post #833750

« Prev Topic | Next Topic »

11 posts, Page 2 of 2

««1 2

Permissions