Something like (not tested)

SELECT * FROM Meetings
  WHERE BeginTime >= @DateTime1 
   AND EndTime <= @DateTime2
   AND DATEADD(min, @TimeNeed, BeginTime ) <= EndTime

>I have a table that contains scheduled cases with the following basic fields:
>
>BeginTime (DT)
>EndTime (DT)
>RoomID (int)
>Table Name is Meetings
>
>A record is placed in the meetings table every time a case is scheduled. I need to create a sp that when passed a parameters (time need, and DateTime1, DateTime2) will return a result set where there is a big enough gap between other cases or following existing cases.
>
>Example Existing Records
>
>

>begintime            endtime           roomID
>------------------------------------------------------------------------
>01/25/2002 07:00  01/25/2002 09:00       1
>01/25/2002 09:00  01/25/2002 10:15       1
>01/25/2002 13:00  01/25/2002 14:00       1
>
>

>
>If I need to time a 1hour slot, I should be able to return at least two options
>10:16 - 11:16, 14:01-15:01.
>
>I figure I will need three parameters. The first the the time needed in minutes, the second & third are the date/time range I want to search from.
>
>It seems I should be able to datediff and dateadd functions to do this, but so far I just end up confusing myself.
>
>Any help greatly appreciated.