Search results for query: *

thanx james but i dont hink it will work for me.. cos i need two dimentional array each row to contain one period and need two of them arrays | periodfrom | period_to | | date | date | | date | date |...

I just found on the MSDN that FOR XML is not valid in subselections Guidelines for Using the FOR XML Clause[shadessad]

Hi everyone I got a stored proc that is getting pretty big, and at this point I got some repeated functionality, which sounds like I need to create a UDF or a stored proc and call it from my main proc. Wot I want to achieve is pass to the function two sets of periods For exaple: FROM...

hello everyone and thanx Pattycake245 for yr answear(really apreciate this). the things ia that i can perform the calculation using only a select . for example a search request may have one to four rooms, each room may have one to five children and their ages.Now for each room and each childen...

Ii’d like to rephrase my question I must return a similar result as the expedia’s searc for hotels. Is it a good idea to select all the rooms and their prices by filtering them by dates and other criterias and them results to store em in table variables and then while I loop for each room and...

hello, I m in the situation that I got to calculate room prices for given periods and depending on their occupancy generate different prices and then apply discounts on each day. So I need at some point, when i get data of different tables to loop through each date from check_in and check_out...

Hi again and thanks a lot for your replies. TNow the rates have two characteristics (keys) one taken of the physical room (each hotel has different types of physical rooms) and another key taken of a period. Now the same room also can have different rates. For example A 3 bed room (occupancy)...

Hello everyone My situation is that I m workin on this project that is about a travel management system. Now at the administration part, we have set up the tables n screens to collect the data for the types of rooms, periods, their discounts, and the rates that will b bought n sold. One of the...

Hello, I ve got a web service that accepts XmlElement as an input parameter. Then within my web method i would like to convert it to sting and then pass the string to my the stored procedure and use OPENXML to insert the values to SQL Server. [WebMethod] public string...