Your right the ISNULL funtion would be a better way of doing this.

Thanks

cls

Thanks everyone for your help on this. It's very much appreciated.

Using a combination of the scripts I received here I resolved my issue as follows:

select a.*,

(case when (select top...

Thanks, it worked.

Not sure why Microsoft would send out a Resource kit with this issue on licensing for thr VPC.

Thank you very much for the help, unfortunately it looks like it pulls in some null records but not all.

Some accounts pull in only a few of the PeriodID's.

You are...

I posted additional information however it doesn't look like it worked so if I duplicate something it is by accident.

I tried using the suggested joins however as soon as I added...

Adding to this question, since I have the same issue.

Can you use DBCC SHRINKDATABASE anytime to shrink the tempDB or should this only be done when the SQL server does not...