Query to find missing time from selected time with in a daterange.

See more:

SQL-Server-2005

SQL-Server

Hi

I need to get a missing time from selected time within a daterange.

Eg.

Inputs

FromDate -18/10/2011,
Todate -19/10/2011
Starttime-8.00PM
EndTime -12.00AM

when i query a table with the above inputs i will get result as follows

18/10/2011 8pm- 9pm
18/10/2011 10pm-11pm
18/10/2011 11pm-12am

19/10/2011 8pm- 9pm
19/10/2011 9pm-10pm


What i need is

18-10/2011 8pm- 9pm
18-10/2011 9pm-10pm---------- this row i have to find.
18-10/2011 10pm-11pm
18-10/2011 11pm-12am

19/10/2011 8pm- 9pm
19/10/2011 9pm-10pm
19/10/2011 10pm-12am---------- this row i have to find.



I have to get this without using the any loop.

Thanks
Ageesh.