Thanks guys. I learned a lot from reading Jeff's articles. Interestingly I had already developed Sort path method (which I called a Tree Path) as well as incorporated CTE's before....

Thanks everyone for your suggestions! I'm going to try them tonight and will report back. Appreciate the help.

Sorry. This solution would not work for me. I understand there are a lot of ways to setup your solution to make it easy to rollup calendar data. But that's...

Interesting. Thank you! I'll try and report back

Great. I appreciate the info. I'll take a look. Thanks

Whew! Thank you very much for that. That did it. Didn't know there was a difference. I'll have to research that to understand it. Thanks!

That did it. Thanks

Thanks for the suggestion. Just read through it and it seems that may be the problem. I'll try it and report back. Thanks!

Ah. Excellent. Makes sense. I'll try it out. Thank you!

There was a bad disk on one the drive of the server. Once it was removed the performance sky rocketed. We're now ongoing through the process of moving everything to...

Ok. After days of reviews and trying different things it appears to have been a hardware problem all along. Thanks everyone for your help

I'm working on Jeff's questions and will respond later today

Data loss is not as much a concern because there daily backups of the server and all the data is coming from a source system that has its own backups...

It in fact turned out to be a security issue. I gave access to the site and the top folder, but apparently that doesn't apply to every folder. So...

Oh wait duh. I see it now. It's two nested sub-queries. Anyway... still great stuff and will have to study the ROW_NUMBER() function.

Thank you! Thank you!