Ruffone
asked on
What is this telling me
Is this query telling me how many users entries were made in my aspnet_Profile table on the particular dates? If so How do I request the total entries for a particular date/month/year.
SELECT Dateadd(day, Datediff(day, 0, LastUpdatedDate), 0) as CreatedOn, Count('UserId') as [Count]
FROM aspnet_Profile
GROUP BY Dateadd(day, Datediff(day, 0, LastUpdatedDate), 0)
ORDER BY 1
2011-02-15 00:00:00.000 145
2011-02-16 00:00:00.000 1196
2011-02-17 00:00:00.000 8046
2011-02-18 00:00:00.000 162
2011-02-19 00:00:00.000 145
2011-02-20 00:00:00.000 4648
2011-02-21 00:00:00.000 4546
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER