advanced code snippet search

Posted By

pauliehaha on 10/20/09


Tagged

aspnet


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


aspnet Registered User Count - Last x days

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT count(1) AS 'Count', Convert(datetime, Convert(int,CreateDate)) AS 'REGISTRATION DATE' FROM aspnet_Membership
  2. WHERE Convert(datetime, Convert(int,CreateDate)) > DATEADD( DAY,-7, Convert(datetime, Convert(int, GetDate())))
  3. GROUP BY  Convert(datetime, Convert(int,CreateDate))

Report this snippet  

You need to login to post a comment.