I have a select statement that includes:
SUM(CASE WHEN E.DateAdded > GetDate() - 7 THEN 1 ELSE 0 END)
But what I would prever is to return something like:
AS 'Since ' + GetDate() - 7
Is there some way to use an expression as the alias?
Also, is there a way to force a column heading to two lines like: