Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-31 : 09:31:44
|
| Scott writes "We are looking for a better method for storing the hours of operation for multiple locations. I thought of using a table such as:LocationID INTDayofWeek INT (1-7)OpenTIme INT (24hr Format)CloseTime INT (24hr Format)And Retrieval as:SELECT *FROM HoursOfOpsWHERE LocationID = @LocIDORDER BY DayOfWeek, OpenTImeIs there a better way of doing this, if we know that there will usually be no more than two sets on any given day?Thanks-Scott" |
|
|
|
|
|
Hours of Operation