Thanks it worked

When i googled everyone using this method STGeomFromText

LocationGeography = geography::STGeomFromText('POINT(@Latitude @Longitude)', 4326)

What is...

While wxecuting...

you should post proper ddl statement,sample data and expected results,so that it will be easy to unserstand and give u some solution

Thanks robert for the reply.

Can u suggest or may be some links to install sql server through windows applications

For Xquery u should refer jacob sebastian blog

http://beyondrelational.com/modules/2/blogs/28/posts/10279/xquery-labs-a-collection-of-xquery-sample-scripts.aspx

This is the image for searching 5 rooms with different adult,child,extrabed combination..i want to get from min adult and child combination to the maximum condition available.

If any room has adult...

Thanks kingston for the solution

Let me check with samples data

Thanks oncce again

For this set of data the results failed

I didn't set the rate for single room on O2/07/2012 but availability is there

so it shouldnot come to the result

And i set the...

All the querys are same except the insert statement for table value parameter...

i just created the search scenarios... for 3 rooms there will be 3 insert statement

for 2 rooms there...

thanks Kingston for the solution

Her is the sample data

I am searching hotel room for the specified checkin and check out date.

If we r searchinhg for room between 2012-07-03 and 2012-07-06,

then it will bring those...

it will not always be(1,2,3)

Lynn Pettis (5/31/2012)

---

Problem is data related:

SELECT 1, '2012-06-01', 50

The data above is a future date and was not anticipated when I wrote the code provided. Here is an apportunity...

Hi Lynn

For the following set of values ..it generating error

INSERT INTO #ProductRate(ProductID,FromDate,Rate)

SELECT 1, '2012-05-01', 10

UNION ALL

SELECT 1, '2012-05-15', 20

UNION ALL

SELECT 1, '2012-05-23', 55

UNION ALL

SELECT 1, '2012-05-26', 55

UNION ALL

SELECT 1, '2012-05-28',...

Thank you very much Lynn Pettis.... it works really fine

Can u explain the CTE part..Taking 10 rows,100 rows

or may be some url

Thanks