ASP.NET / VB / MS SQL: Implement Complex SQL Queries

进行中 已发布的 Aug 1, 2012 货到付款
进行中 货到付款

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.

.NET SQL Visual Basic

项目ID: #2368896

关于项目

11个方案 远程项目 活跃的Aug 1, 2012

授予:

kevlar1000pro

I have the experience, so i can do it. Contact me for more details. Thanks

$50 USD 在1天内
(0条评论)
0.0

有11名威客正在参与此工作的竞标,均价$45/小时

manhpham

I am SQL expert. Please see my feedbacks to make your decision. I am ready to help you.

$40USD 在1天里
(26条评论)
4.8
Codoc1010

Hi, your job is easy for me. I ready to your job. I sure, i can complete soon. Thanks!

$30USD 在1天里
(16条评论)
4.6
contactfordotnet

Hi, Please check your PM.

$70USD 在1天里
(7条评论)
4.6
agiletechonline

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 更多

$30 USD 在2天内
(13条评论)
4.4
developer0106

Hi, I can do your task. Please check your inbox for more details. Thank you.

$50 USD 在0天内
(5条评论)
3.6
kfanx

I can do it perfectly! Thank you very much!

$30 USD 在0天内
(1条评论)
2.1
VLSuresh

Hello Mr Respectable client i can complete the work in the given time with more proficiency .. please contact me

$70 USD 在2天内
(0条评论)
0.0
dotnetcrazy1

I have four years of experience in sql,vb.net check the pm.

$30USD 在1天里
(0条评论)
0.0
teratechnolab

I am interested to work on this problem. Thanks.

$50USD 在1天里
(0条评论)
0.0