Friday, March 27, 2015

Assigning avg to columns and grouping that info by date

HI



SELECT COUNT(acct),CASE WHEN LEN(CAST(month(D_TIME) as Varchar(10))) = 1 THEN '0'+CAST(month(D_TIME) as Varchar(10)) ELSE CAST(month(D_TIME) as Varchar(10)) END + CAST(year(D_TIME) as Varchar(4)),AVG(TOKEN)
FROM #TEST1
GROUP BY CASE WHEN LEN(CAST(month(D_TIME) as Varchar(10))) = 1 THEN '0'+CAST(month(D_TIME) as Varchar(10)) ELSE CAST(month(D_TIME) as Varchar(10)) END + CAST(year(D_TIME) as Varchar(4))






No comments:

Post a Comment