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 |
|
egghi
Starting Member
17 Posts |
 Posted - 2006-11-08 : 15:56:57
|
| Hi,I have a table which records employees'time-off records. There are 6 columns in this TimeOff table. They are RequestID, EmpName, StartDate, EndDate, Type, NumofDays. I have another table which has all the dates from 01/01/1950 to 01/01/2056.I am trying write a query which lists all the dates between the timeoff startdate and enddate, including the the start and end dates, but my query so far only lists the start and end date in a timeoff record:SELECT D.[Date], Datename(dw,D.[Date]) AS WeekdayFROM Dates D LEFT JOIN TimeOff T ON D.[Date] = T.OffStartDate OR D.[Date] = T.OffEndDateWHERE (OffType = 'Sick Day' AND EmpName = 'Cat White') AND (D.[Date] BETWEEN T.StartDate AND T.EndDate)Any advice will be greatly appreciated! |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-08 : 16:07:09
|
| Seehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519 |
 |
|
|
|
|
|
Generate dates between two dates