please help ............
Hi, you are right as my table is not in first normal form. but data is comming from xml and i check my date like ' 10 oct 2005' so this is not...
that was my al data of my abc table. now what i need. like if i have three record roomcode startdate enddate 2404 5 oct 2005...
375Double Standard2221~2~3~4~5~6~70000860120541994/1/20036/30/20034375 375Double Standard2221~2~3~4~5~6~70000800120541997/1/20038/31/20034376...
1178Triple Standard3301~2~3~4~5~6~70001700519721995/1/20038/31/20034164 1178Triple Standard3301~2~3~4~5~6~70002200519721999/1/20031/31/20044165...
1259Single Room Standard1101~2~3~4~5~6~7000591191719911/1/20033/31/20044048 1260Double Standard2201~2~3~4~5~6~70000470119171994/1/200310/31/20034047...
this is my table structure this is the table structure CREATE TABLE [dbo].[abc] ( [room_code] [int] NOT NULL , [room_name] [varchar] (101) COLLATE...
select * from roomfaredetails where room_code in(select room_code from roomfaredetails where room_code in (select room_code from roomfaredetails...
sorry it is not working . And actually i need all the row not sum of price
Hi, Suppose Between 10 Oct to 25 Oct i want to know the price of a room Room_code Days price checkin checkout R001...
either you guys are not getting me or some thing else?? but this is not the solution of my problem i need simple all room that exists between two...
Thanks Goswami, But by this query we got only those rows which has date between 10 Oct 2005 to 25 oct 2005 in same row . if i have three record...
room_code Days Price checkin checkout R001 Mon,Tue 100 10 Oct 2005 17...
Separate names with a comma.
