@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

083044124014........... 2012-08-15 ..........2012-08-25750.009210021234567

083744124011........... .....2012-08-20 ..........2012-09-28750.009210021234567

0855412 2013..................2012-08-15......... 2012-09-30450.009201112345678

123456783014................2012-08-22 ..........2012-08-29450.000987654321123

123456781015 ................2012-08-20..........2012-09-23450.000987654321123

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.

1011AvailSTD1

1012AvailSTD1

2011AvailDLX2

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.