Q&A about the site for developers and end users of the Sitecore CMS and multichannel marketing software
-- How many answers did I submit on different days?
DECLARE @UserId int = ##UserId##
CONVERT(DATE, MIN(CreationDate), 120) AS Ans_Date,
COUNT(*) AS Answers
WHERE Posts.PostTypeId = 2 AND Posts.OwnerUserId = @UserId
GROUP BY CAST(Posts.CreationDate AS DATE)