Hi Jack,

This code will need to run on both 2000 and 2005, so I assume that I do not have the CTE option. Am I correct?

It was my hope to use this as a view so that clients who create their own reports with a variety of report writers would be able to derive a...

Jack,

Thanks for for creating a simple, easy to implement solution for this issue.

M. Saint

Wow Lynn,

For someone who is accustom to accomplishing this using VB6 or C# loops, this is really an amazing piece of code. I will have to abosorb this. ...

No

The room in this example is occupied for each day between the day it was occupied and the day it was vacated.

If the data included a record for each day,...

The negative data indicates the occupant(s) vacated the room. Positive numbers indicate that the room is occupied.