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 - 2005-12-20 : 07:56:33
|
| Oren writes "i have a table of appointments in my data base that contains a column of date. I have to get all the free dates(days that contain no appointments) in the next 3 years. How can i do sql query that returns these dates." |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-20 : 08:13:51
|
| You can refer to this [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58310[/url]-----------------[KH]Learn something new everyday |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-20 : 08:47:46
|
| Have a table that has all Dates and do query based on what are missing as suggested at that linkMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Get free dates query