Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to filter this query
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
How to filter this query
Miscellaneous
Thread ID:
00737335
Message ID:
00737335
Views:
52
I'm hoping to limit the query below to return only records who's ProcCount is equal to or greater than the coProc.ActivityAlertLevel value. Any help appreciated.
declare @ltQueryFrom datetime
declare @ltQueryTo   datetime

set @ltQueryFrom = '10/01/2002 00:00:00'
set @ltQueryTo   = '10/31/2002 23:59:59'


SELECT COUNT(dbo.meetproc.procid) AS ProcCount, 
	dbo.coper.lastname, 
	dbo.coper.firstname, 
	dbo.meetproc.procid, 
        dbo.coproc.description
FROM    dbo.meetings INNER JOIN
        dbo.meetproc ON dbo.meetings.meetingnumber = dbo.meetproc.meetingnumber INNER JOIN
        dbo.coper ON dbo.meetproc.coperid = dbo.coper.coperid INNER JOIN
        dbo.coproc ON dbo.meetproc.procid = dbo.coproc.procid
WHERE     (dbo.meetproc.coperid > 0) 
	AND (dbo.meetings.iscancelled = 0) 
	AND (dbo.coproc.ActivityAlertLevel > 0)
	and meetings.Begintime between @ltQueryFrom and @ltQueryTo
GROUP BY dbo.coper.coperid, dbo.coper.lastname, dbo.coper.firstname, dbo.meetproc.procid, dbo.coproc.description
ORDER BY dbo.coper.lastname, dbo.coper.firstname
Thanks
Kirk
Next
Reply
Map
View

Click here to load this message in the networking platform