ASP.NET / VB / MS SQL: Implement Complex SQL Queries
$30-70 USD
货到付款
I have a website that is powered by ASP.NET / Visual Basic and Microsoft SQL.
The website is working except for one page that requires several very complicated SQL queries.
Results are not grouped correctly.
For example, a building may have 20 "One Bedroom" units and 10 "Two Bedroom" units.
There are 30 total units but only 2 types. Only the two types should be displayed on my webpage like this:
---------------------------------------------
Unit Type: One Bedroom
Rent: $100 - $200
Size: 500 Square Feet up to 900 Square Feet
Availability: Yes
---------------------------------------------
Unit Type: Two Bedroom
Rent: $200 - $300
Size: 700 Square Feet up to 950 Square Feet
Availability: No
---------------------------------------------
However because the SQL query is not grouped correctly, I get 30 results instead of 2.
项目ID: #2368896
关于项目
授予:
有11名威客正在参与此工作的竞标,均价$45/小时
Hello, We are a team of developers who are experts in .Net technology and working on this field for more than 7 years and already used this type of query in the Hotel Reservation application which we previously bui 更多
Hello Mr Respectable client i can complete the work in the given time with more proficiency .. please contact me