imti
Member
- Joined
- Jun 15, 2005
- Messages
- 7
- Programming Experience
- Beginner
as u can see at room no 109 there is no customer
and its on first floor
in my db design , room and floor are fixed for the hotel
so what wud be the query to insert customer in room no 109
along with RentDate,LeavingDate,Contract
pls pls let me know asap
thx in advance
imti
roomno cusid floor rentdate leavingdate contract
101 8 1 3000-03-03 00:00:00.000 4090-04-04 00:00:00.000 4
102 1 1 3000-02-02 00:00:00.000 3003-03-03 00:00:00.000 4
103 2 1 2000-02-02 00:00:00.000 3000-03-03 00:00:00.000 4
104 3 1 NULL NULL NULL
105 4 1 NULL NULL NULL
106 5 1 NULL NULL NULL
107 6 1 2000-02-13 00:00:00.000 NULL NULL
108 7 1 NULL NULL NULL
109 NULL 1 NULL NULL NULL
110 NULL 1 NULL NULL NULL
201 NULL 2 NULL NULL NULL
202 NULL 2 NULL NULL NULL
203 NULL 2 NULL NULL NULL
204 NULL 2 NULL NULL NULL
205 NULL 2 NULL NULL NULL
206 NULL 2 NULL NULL NULL
207 NULL 2 NULL NULL NULL
208 NULL 2 NULL NULL NULL
209 NULL 2 NULL NULL NULL
210 NULL 2 NULL NULL NULL
301 NULL 3 NULL NULL NULL
302 NULL 3 NULL NULL NULL
303 NULL 3 NULL NULL NULL
304 NULL 3 NULL NULL NULL
305 NULL 3 NULL NULL NULL
306 NULL 3 NULL NULL NULL
307 NULL 3 NULL NULL NULL
308 NULL 3 NULL NULL NULL
309 NULL 3 NULL NULL NULL
310 NULL 3 NULL NULL NULL
401 NULL 4 NULL NULL NULL
402 NULL 4 NULL NULL NULL
403 NULL 4 NULL NULL NULL
404 NULL 4 NULL NULL NULL
405 NULL 4 NULL NULL NULL
406 NULL 4 NULL NULL NULL
407 NULL 4 NULL NULL NULL
408 NULL 4 NULL NULL NULL
409 NULL 4 NULL NULL NULL
410 NULL 4 NULL NULL NULL
and its on first floor
in my db design , room and floor are fixed for the hotel
so what wud be the query to insert customer in room no 109
along with RentDate,LeavingDate,Contract
pls pls let me know asap
thx in advance
imti
roomno cusid floor rentdate leavingdate contract
101 8 1 3000-03-03 00:00:00.000 4090-04-04 00:00:00.000 4
102 1 1 3000-02-02 00:00:00.000 3003-03-03 00:00:00.000 4
103 2 1 2000-02-02 00:00:00.000 3000-03-03 00:00:00.000 4
104 3 1 NULL NULL NULL
105 4 1 NULL NULL NULL
106 5 1 NULL NULL NULL
107 6 1 2000-02-13 00:00:00.000 NULL NULL
108 7 1 NULL NULL NULL
109 NULL 1 NULL NULL NULL
110 NULL 1 NULL NULL NULL
201 NULL 2 NULL NULL NULL
202 NULL 2 NULL NULL NULL
203 NULL 2 NULL NULL NULL
204 NULL 2 NULL NULL NULL
205 NULL 2 NULL NULL NULL
206 NULL 2 NULL NULL NULL
207 NULL 2 NULL NULL NULL
208 NULL 2 NULL NULL NULL
209 NULL 2 NULL NULL NULL
210 NULL 2 NULL NULL NULL
301 NULL 3 NULL NULL NULL
302 NULL 3 NULL NULL NULL
303 NULL 3 NULL NULL NULL
304 NULL 3 NULL NULL NULL
305 NULL 3 NULL NULL NULL
306 NULL 3 NULL NULL NULL
307 NULL 3 NULL NULL NULL
308 NULL 3 NULL NULL NULL
309 NULL 3 NULL NULL NULL
310 NULL 3 NULL NULL NULL
401 NULL 4 NULL NULL NULL
402 NULL 4 NULL NULL NULL
403 NULL 4 NULL NULL NULL
404 NULL 4 NULL NULL NULL
405 NULL 4 NULL NULL NULL
406 NULL 4 NULL NULL NULL
407 NULL 4 NULL NULL NULL
408 NULL 4 NULL NULL NULL
409 NULL 4 NULL NULL NULL
410 NULL 4 NULL NULL NULL