@ben.brugman, thanks my brother you information real helped me to get /correct the problem I was experiencing.

Now my program is working .

Booking_ID R_No........... Arrv_Date .............Dep_Date

08304412 4014........... 2012-08-15 ..........2012-08-25 750.00 9210021234567

08374412 4011........... .....2012-08-20 ..........2012-09-28 750.00 9210021234567

0855412 2013..................2012-08-15......... 2012-09-30 450.00 9201112345678

12345678 3014 ................2012-08-22 ..........2012-08-29 450.00 0987654321123

12345678 1015 ................2012-08-20..........2012-09-23 450.00 0987654321123

Arrival Date :2012-08-30 Departure date...

It must return rooms that are not booked at those dates.

I'm a university student and I'm developing a database for a hotel system ,now I'm stack when I try to check rooms that are available for a specific date,room_status and...

create table Rooms

(Room_no char(4) primary key not null,

Room_Status varchar(20) not null,

Room_Type_Code char(4) foreign key references Room_Type(Room_Type_Code))

go

Data in the Table.

1011 Avail STD1

1012 Avail STD1

2011 Avail DLX2

Create table Room_Bookings

(Booking_ID char(8) NOT NULL ,

Room_no char(4) NOT NULL Foreign KEY...

@

I ddnt knw posting the same post many time is spamming ,I was trying to get help as quick as possible. The project tht I'm doing is industrial not a...

Mr Jones told me to post here,so I dnt knw wat you mean now. give me the link of that forum.