SELECT
SUM(CASE WHEN Month(Trans_Date) = 1 THEN 1 ELSE 0 END) AS CONVERT(CHAR(4), Trans_Date, 100) + CONVERT(CHAR(4), Trans_Date, 120)
FROM table.Trans
SELECT
SUM(CASE WHEN Month(Trans_Date) = 1 THEN 1 ELSE 0 END) AS CONVERT(CHAR(4), Trans_Date, 100) + CONVERT(CHAR(4), Trans_Date, 120)
FROM table.Trans
Looks like a candidate for some dynamic sql to me, although I'm not a massive fan of it.
Something like:
DECLARE @DynamicSql NVARCHAR(MAX) = ''; SELECT @DynamicSql = 'SELECT YourColumnsETC as ' + CONVERT(CHAR(4), YourColumn, 100)+ ' FROM YourTable;' EXECUTE SYS.SP_EXECUTESQL @DynamicSql
18 People are following this question.