SELECT DATEADD(DAY, DATEDIFF(DAY, 0, SMD.CreatedDate), 0) AS CreatedOn
,COUNT(SMD.CreatedDate) as [Count]
FROM TableName SMD
GROUP BY DATEADD(DAY, DATEDIFF(DAY, 0, SMD.CreatedDate), 0)
,COUNT(SMD.CreatedDate) as [Count]
FROM TableName SMD
GROUP BY DATEADD(DAY, DATEDIFF(DAY, 0, SMD.CreatedDate), 0)
No comments:
Post a Comment