That seems to have done the trick... I had to bring in the companies table to do a cross join as you said:

SELECT Companies.ID AS CID,...

The third column is just the indicator (yes/no) on whether that Company has that module. I thought of using count() to get a 0 or 1 but it doesn't...

Fyi... i solved this issue a different way... see http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2564725&SiteID=1

I am having the same issue. Running SQL 2005, the stored proc works for a period of time and then suddenly it stops working giving the DLL initialization error when...