Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xtech
Starting Member
6 Posts |
 Posted - 2009-07-13 : 16:33:50
|
| Hi,I've written a SQL script to retrieve data on service calls clients have had within a specific time frame, with associated technician name, etc. and it works perfectly. However, when I attempt to filter it further using aggregate functions, and have only clients with more than 3 service calls, I run into a problem - nothing is returned. The failing SQL with the count() functions is listed below. Would appreciate any insight into the issue.Thanks to one and all.xtech |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Aggregate function problem - count()