>I've got four tables.
>
>- Doctors
>- Patients
>- Rosters
>- Appointments
>
>The roster table will contain one record per roster, saying that a roster is valid trough a date range. Describing a roster with a start time, end time and the length (minutes) of the timeslots
>
>Now give three overviews of the appointments.
>- One detailed (Select a doctor and you will get a detailed overview of appointments with patients)
>- One daily (Overview of appointments of all doctors)
>- One weekly (Overview of appointments of one week of a selected doctor)
>- One monthly (Overview of appointments of one month of a selected doctor)



I'll tell you what....this would be a great topic for an article about ways to implement this in .NET...using stored procedures, or alternative middle-ware data munging if a server-based approach isn't viable.

Is there anything proprietary or confidential about the schema, output format, etc. (Obviously, dummy data would need to be populated, but I wanted to make sure there wasn't anything confidential.

Thanks,
Kevin