Dynamic query column name

[99Chuck99]

New to SQL server and was wondering if the following snipit of code can be done. I would like to name the column in the query to the month with the AS statement. Thanks in advance.

SUM(CASE WHEN datepart(MONTH, (DATEADD(M, - 1, GETDATE())))= DATEPART(MONTH, dbo.ACTION.ACTION_DATE) THEN 1 ELSE 0 END) AS datepart(MONTH,(DATEADD(M, - 1, GETDATE()))),

 

[r937]

no

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[99Chuck99]

Thank you.

 

[99Chuck99]

Does anybody have any ideas on how I could achieve this type of dynamic field naming. I'm tring to pull current month and the two previous months at any period of the year. Thanks again....

 

[bborissov]

Why?
That will make your frontend much more difficult.
Better stay with constant recordsset, than to make your frontend code unreadable

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.