I have a DotNet site that I am creating some reports for with SQL Reporting Services 2005 and I need to build a query that will show me the following:
1. Active Users (logging into site within last 6 months)
2. Inactive Users (have not logged into site within last 6 months)
This is from the standard aspnet_Users log table. The date field to query is called "LastActivityDate".
TIA for any expert knowledge!