Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    1

    MS SQL Query for Date/Time Criteria

    Hi,

    I am working on Conferance Booking Application

    senario : following date and time range already existing for Room ID 1

    Booking From Date Booking To Date Start Time End Time
    2006-06-19 2006-06-19 11.00 18.00
    2006-06-20 2006-06-20 13:00 16:00
    2006-06-20 2006-06-21 16:00 12:00

    I want to book the same room ID between date 2006-06-19 and 2006-06-20 from 19.00 to 12.00

    for the above, first I need to find out the existing status for the room ID 1 and if query returns the zero record then its consider free slat you can the room id 1 between new mentioned date and time

    I need query which gives me the desired result

    waiting for response........

    thanks
    ravi shiggavi
    Last edited by ravishiggavi; 06-16-06 at 13:00.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    what makes you beleive you are have a good chance to get an answer on an MS SQL server question in the new members thread?

    I'd reccomend that you try the MS SQL thread instead....
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •