advanced code snippet search

Posted By

pauliehaha on 03/10/09


Tagged

aspnet


Versions (?)

ASP.NET Membership Provider - Registered Users Active Within the Past [Month]

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT COUNT(1) FROM aspnet_Users 
  2. WHERE DATEDIFF(MONTH, LastActivityDate, getdate()) <= 1

Report this snippet  

You need to login to post a comment.