April 12, 2007 at 3:08 pm
Hello,
I am hoping you folks may be able to point me in the right direction.
I would like to create an SQL Server 2005 database. This database will be used to schedule appointments with 15 minute intervals. ColdFusion and Flex will be used for the front end.
My background is primarily graphics so although I am not a techno peasant but am far from an SQL professional.
Thanks much
April 13, 2007 at 6:58 am
So.... you want what? Advice on Training? Solid Quality Learning has some of the best courses I've ever been to.
Books? The "Inside SQL Server" series is a little advanced, but it'll get going.
After that, I'm not sure what you expect from this question.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 13, 2007 at 8:26 am
Thanks for your response Grant.
Reading over my post I see that it is vague.
I specifically want to know how to best set up a tables for scheduling appointments.
I thought I could set up tables with start and end times using 15 min time slices but fear my database could become somewhat bloated rather quickly.
I will take a look at the reference material you suggested.
Thanks again for your help
April 13, 2007 at 8:36 am
Hey,
Getting a design is usually very dependent on business needs, but you should be able to set up the database to accept any given start & stop time and then rely on the UI to display the stuff within increments like Outlook does. That will make the storage in the database a lot easier.
If you've got specific questions, post 'em.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply