Originally Posted by Dimitar

MapGeek,

Could you try aliasing the subquery:
SELECT COUNT(*) FROM (SELECT ...) as u

I am not a SQL Server user so I might be completely wrong in my guess.

Hope this helps.
Dimitar