Jason (JayCallas@hotmail.com) writes:
> I did forget to ask a question. When I run your code I receive the
> following message: 'Warning: Null value is eliminated by an aggregate
> or other SET operation.'
>
> Should I care about this?

No. The cause are these expressions:

COUNT(DISTINCT NULLIF(subtype,''))

You might be able to rewrite this, but I leave that to David. :-) If the
messages bother you, you can embed the query with SET ANSI_WARNINGS OFF and
SET ANSI_WARNINGS ON.



--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp