is it possible to add a datepart to the alias of a summed case statement

Question

question

Layo asked Mar 6, '19

is it possible to add a datepart to the alias of a summed case statement

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

case-statement datepart

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2019-03-06T16:34:24Z

WRBI answered Mar 6, '19

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

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question