Worked like a charm... THANKS!!!!

You are right.  I think that I might do that.  It is just a DTS copy that is imported nightly anyway.  I just don't like to make changes because it...

I agree it is a huge problem.  But here is the deal.  I cannot change it.  It is a third party database and cannot really be changed.  I know it sux.  I...

Problem is that [CustomerInfo] has no unique ID column.  Any ideas?

SIC is not always null just in my example.

I apologize for my original post.  It was vague, incomplete and yes; the capitalization sucks (trying to keep with the capitalization that the database vendor...

Okay.  I have pared down the query to:

SELECT Dept, OPID, [Count]

FROM (

 SELECT p.dept as Dept, p.csr as OPID, count(*) as [Count]

 FROM policy as p

 WHERE p.Dept is not null and p.csr...