<div>
Both work - thank you. &nbsp;Ewangoya's solution is easier for me to implement as the tables already exist and showed me how to avoid the 'collisions'... all help much appreciated!
</div>


Both work - thank you.  Ewangoya's solution is easier for me to implement as the tables already exist and showed me how to avoid the 'collisions'... all help much appreciated!

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I'm working on a booking engine and would like to know if anyone knows the best way to search a db for availability. &nbsp;For example, a customer could search for July 1st 2012 +/-7 days, for a 7 day stay, so the query needs to check that there is no booking, either between the June 24th to July 1st, or June 25th to July 2nd, or June 26th to July 3rd etc., right up to July 7th to July 14th.<br />
<br />
My DB at the moment has start and end dates, but I'm simply not sure of the best way to do this...!<br />
<br />
Please help! &nbsp;Thanks :-)
</div>
</div>


Hello Experts,

I'm working on a booking engine and would like to know if anyone knows the best way to search a db for availability.  For example, a customer could search for July 1st 2012 +/-7 days, for a 7 day stay, so the query needs to check that there is no booking, either between the June 24th to July 1st, or June 25th to July 2nd, or June 26th to July 3rd etc., right up to July 7th to July 14th.

My DB at the moment has start and end dates, but I'm simply not sure of the best way to do this...!

Please help!  Thanks :-)

Search MS SQL DB for available dates

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.