troubleshooting Question

How to format Column Header

Avatar of ALawrence007
ALawrence007 asked on
Microsoft SQL ServerMicrosoft SQL Server 2005SQL
10 Comments1 Solution231 ViewsLast Modified:
Hi,

I hope that this is possible. My query below generates a total for a month in my SQL database. As you can see the Column header is hard coded as [Feb Total] at the moment. Can I make that Dynamic so that if the month changes the column header changes as well. It does not HAVE to be the month name, but could also be '02/01/2008' if needs be.

Thanks
Declare @Month DateTime  
Set @Month = '02/01/2008'  
SELECT     SUM(CASE WHEN ([Transaction].Time BETWEEN DATEADD(month, DATEDIFF(month, 0, @Month), 0) AND DATEADD(month, DATEDIFF(month, 0, @Month) + 1, 0)) 
THEN [Transaction].Total ELSE 0 END) AS [Feb Total]
FROM         [Transaction] INNER JOIN
TransactionEntry ON [Transaction].TransactionNumber = TransactionEntry.TransactionNumber
WHERE     ([Transaction].Time BETWEEN DATEADD(month, DATEDIFF(month, 0, @Month), 0) AND DATEADD(month, DATEDIFF(month, 0, @Month) + 1, 0))
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros