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