Yes, the view 2005 queries a 2012 db successfully (including nulls). The three versions are:

Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86)

Mar 25 2011 13:50:04

Copyright (c) 1988-2005...

The view, on 2005. The orgName from the left outer join is the field I'm currently looking at, and that is used for the following queries.

SELECT ...

The value is actually null, not a string. The 3 queries suggested are what I ran to get the counts in my first post. Run from the 2005 server, they...

Depending on what you are trying to accomplish, I believe you either need to look at the data source view (if you only ever need 1 particular company) or row-level...