Building a table for a schedule

[NicktheNewbie]

Has anyone ever built table(s) for a schedule/appointment from end?

I'm building a system that allows for the entry and tracking of appointments, and I'm wondering about the most effective way to store this information. It will have an ASP front end, and I'll be building a series of tables to store the schedule/appointment info. Users will make the schedule, then outside parties will see lists of appointments on either a monthly, weekly or daily schedule.

I would welcome any suggestions on how to manage this type of data - what columns make the most sense, what format the data should be stored in to maximize efficeny and speed, etc.

Thanks!

 

[SQLSister]

Suggestion 1, store all date information in a datetime or smalldatetime data type.



Questions about posting. See faq183-874