IT mean 3 * 0 = 0

SELECT COUNT(t2.StudentID)

FROM

(SELECT StudentID

FROM Attendance

WHERE ClassId=1 and MONTH(Date)=11 and status=0

GROUP BY studentID

HAVING COUNT(studentid)>2...

I think not client directly connect to DB Server. It may be a service or some middleware in an application server do. The application Server and DB server are either...

Thanks 4 all. I found the answer.

http://support.microsoft.com/default.aspx?scid=kb;en-us;296769