<div>
if 'per month' means the latest month, then give this a whirl..
<pre><code id="code-20-39524977-1">SELECT s.DeviceID, c.custName
FROM (
	SELECT DeviceId, COUNT(DeviceID) as the_count
	FROM Session 
	WHERE Off_Date_Time &gt; DATEADD(m, -1, GETDATE()) 
	HAVING COUNT(DeviceID) &lt; 5 ) s
	JOIN Customer c ON s.DeviceID = c.DeviceID</code></pre>
Replace -1 and 5 with -3 and 10 for 'less than 10 times per 3 months'.
</div>


if 'per month' means the latest month, then give this a whirl..

SELECT s.DeviceID, c.custName
FROM (
	SELECT DeviceId, COUNT(DeviceID) as the_count
	FROM Session 
	WHERE Off_Date_Time > DATEADD(m, -1, GETDATE()) 
	HAVING COUNT(DeviceID) < 5 ) s
	JOIN Customer c ON s.DeviceID = c.DeviceID

Replace -1 and 5 with -3 and 10 for 'less than 10 times per 3 months'.

<div>
I just spent 10 minutes writing a cte query that would do this but experts-exchange threw it away because I wasn't already logged in.<br />
<br />
sry
</div>


I just spent 10 minutes writing a cte query that would do this but experts-exchange threw it away because I wasn't already logged in.

sry

<div>
Hi!<br />
<br />
Jimhorn:<br />
it will not work. 'multipart identifier could not be found'
</div>


Hi!

Jimhorn:
it will not work. 'multipart identifier could not be found'

<div>
Perfect!<br />
<br />
Thank You.
</div>


<div>
Thanks for the grade. &nbsp;Good luck with your project. &nbsp;-Jim
</div>


Thanks for the grade.  Good luck with your project.  -Jim

<div>
<div class="content wysiwyg-content">
Hi !<br />
<br />
i need to find users &nbsp;logged-in less then 5 times per month and less then 10 times per 3 months.<br />
<br />
Table layouts.<br />
<br />
Customer table.<br />
DeviceId, Custname,,,,,,,,,,,,<br />
<br />
session table<br />
Sessions_Id, DeviceId, on_date_time, Off_Date_Time, Complete,,,,,,,,,,,,,<br />
<br />
need it to output<br />
<br />
custname &nbsp;deviceId
</div>
</div>


Hi !

i need to find users  logged-in less then 5 times per month and less then 10 times per 3 months.

Table layouts.

Customer table.
DeviceId, Custname,,,,,,,,,,,,

session table
Sessions_Id, DeviceId, on_date_time, Off_Date_Time, Complete,,,,,,,,,,,,,

need it to output

custname  deviceId

sql query, finding  users  who logged in less than 5 times per month / 10 times per 3 months

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.