Also if you please, how are @time, @deptime, @exparrtime, @entdate declared?

The last select shows [IfLate] - assuming a typo and [IsLate] is correct. I'd kindly request you copy and...

A newbie myself, am in the middle of Ben-Gan's "Microsoft SQL Server 2008 T-SQL Fundamentals". Superior book with core knowledge given in a logically incremental fashion. Let's you...

Hi David,

I'm not sure who Andrew is, but I'm baffled as to why the code I posted didn't work since it was a cut and paste from a working query...

Hope this what you're looking for:

select surname, givenname

from community as cm join constits as cn on cm.id = cn.id

where cn.constit = 'PC'

and not exists (...