dhandapani Question Asked 2 Years ago through
ASK
<p>SELECT COUNT(COURSEID) AS [COUNT], UPPER(DATENAME(MONTH,CONVERT(VARCHAR(50),DATEADD (MM, 0, STAMP),106))) <br />AS [MONTH] <br />,DATENAME(YY,STAMP) AS [MONTH] <br />FROM SESSIONSTATS <br />WHERE STAMP BETWEEN STAMP AND GETDATE() and datedif...
|
ask
92
·
2% ·
491
|