Home Forums SQL Server 2008 T-SQL (SS2K8) Need help in putting the correct WHERE Clause RE: Need help in putting the correct WHERE Clause
e4d4
SSCertifiable
Points: 5777
More actions
January 6, 2013 at 4:39 am
#1574114
Not WHERE clause, but HAVING, because you want filter out groups. Add after GROUP BY block HAVING Max(WQ.WorkQueueEndWorkDate))%3600/60)>=120
HAVING Max(WQ.WorkQueueEndWorkDate))%3600/60)>=120