Overlap Analysis

[Clarence W. Robison]

Greetings,

I need to do an analysis of resource usage based on an existing table like:

  create table ResUsage( +
     ResType Text 16, +
     ResID Text 8, +
     CheckOut DateTime, +
     CheckIn DateTime, +
     EmpID Integer ) 

I need to generate a report something like this

        Resource: <ResType>
  Usage Report from mm/dd/yyyy to mm/dd/yyyy

  Number Concurrently Checked Out          Duration
              1                        42 hours 15 mins
              2                        36 hours 33 mins
              3                        28 hours 10 mins
              4                        12 hours 50 mins
              5                         6 hours 35 mins
              6                         0 hours  0 mins

Does anyone have ideas on how to generate this summary data with a few SQL 
statements or a relatively simple procedure file?

Thanks in advance
Clarence
Clarence W. Robison, P.E.
[EMAIL PROTECTED]