I have a holidays table which records holidays taken by individuals.
The table has three columns
I need to return all rows where a holiday period would include any of the
I am thinking something along the lines of
select * from Holidays_table where
) between [ Start_date] and [end_date}
Then repeat the select statement for each date needed using UNION
this is my starting point but any guidance or ideas appreciated....
i have the dates stored in another table and i can get them with the following query
select date from dbo.[holidays]