I agree with John, the better the example, the better the help.

From the sounds of it you are on the right track. Using Outer join instead of inner join...

How is the security on the linked server setup?

Since you are new to SQL this is a good learning opportunity. What I think you want to do is to have BO, CT and Total in the same...

I would say all you need to do is joins the results of the 3 views on the cleareddate column.

bocleared cleareddate ctcleared cleareddate totalcleared cleareddate

2 1/2/2009 ...

Are you seeing any errors in the Application or system event logs at the same time as the errors in sql server log? I am seeing the same errors in...

This probably will not return the correct results based on original query you posted. You will get something that looks right but the data may be wrong.

Again look online for...

What I posted is an example. It has nothing to do with your actual query except demonstrating what changes you would need to make in your own. Since you don't...

A quick example on how you can get you results. Just take the example and apply it to your query.

This code creates the test data

create table ocode(

officecodevarchar(2),

datedatetime,

numint)

insert into ocode

select 'bo',getdate(),1

union...

After re-reading the question, there may be an easier way to get what you need without a pivot table. in your CTE, include Office Code as one of the columns...

I think the using PIVOT command may be able to get you your results.

http://technet.microsoft.com/en-us/library/ms177410.aspx

The following will give you similar info, product level states SP.

select serverproperty('ProductVersion') as ProductVersion,serverproperty('Edition') as Edition,serverproperty('ProductLevel') as ProductLevel

and this link has list of build version

http://www.sqlservercentral.com/articles/Administration/2960/%5B/url%5D

the registry path this would be located in is

HKEY_CLASSES_ROOT\Installer\patches

As for whether you should install the SP2 or RTM support files or do it at all since it installed correctly i cant say because me situation was not exactly...

I think they were the originals right off the CD.