Click here to Skip to main content
16,012,110 members

Comments by Member 8921522 (Top 8 by date)

Member 8921522 29-Aug-12 5:33am View    
Here I have 2 table first AgentPackagePrice And Second Bookdate

I have some value in first table & with some colum of 1st table or more column in 2nd table i want to get only those colun where date between given date or date can be null
Member 8921522 29-Aug-12 5:23am View    
Select Distinct(S1.RoomType),t.HotelName,S1.CIN From AgentPackagePrice t , BookDate S1 Where t.PackageNo=S1.PID Or '2012-12-22 00:00:00.000'
Between S1.CIN And S1.COUT And t.HotelName='ANCASA EXPRESS' and t.RoomType=S1.RoomType

Thats My Query
Member 8921522 14-Aug-12 6:02am View    
Thank u its work
Member 8921522 7-Aug-12 8:25am View    
ok thank you
Member 8921522 7-Aug-12 8:23am View    
I want to generate grid view at run time & how many grid are generate at run time it based on condition.& I also generate some coloum in grid view at run time ..