En cours

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

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.

Compétences : .NET, SQL, Visual Basic

Voir plus : rent asp, get asp net, microsoft asp.net, SQL Query, sql queries, sql microsoft, Sql 2012, queries, microsoft sql website, sql query results asp page, implement 2012, queries sql, example visual basic, sql visual basic 2012, microsoft asp, basic webpage, hknight, sql implement, building rent, microsoft visual basic net, complex net, basic SQL , net visual basic, sql query sql query, working sql vb

Concernant l'employeur :
( 59 commentaires ) Pictou, Canada

N° du projet : #2368896

Décerné à :

kevlar1000pro

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

50 $ USD en 1 jour
(0 Commentaires)
0.0

11 freelance ont fait une offre moyenne de 45 $ pour ce travail

manhpham

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

40 $ USD en 1 jour
(26 Commentaires)
4.8
Codoc1010

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

30 $ USD en 1 jour
(16 Commentaires)
4.6
contactfordotnet

Hi, Please check your PM.

70 $ USD en 1 jour
(7 Commentaires)
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 Plus

30 $ USD en 2 jours
(13 Commentaires)
4.4
developer0106

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

50 $ USD en 0 jours
(5 Commentaires)
3.6
kfanx

I can do it perfectly! Thank you very much!

30 $ USD en 0 jours
(1 Commentaire)
2.1
VLSuresh

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

70 $ USD en 2 jours
(0 Commentaires)
0.0
btslx

Dear Buyer, We are highly interested to work on your project , please send the full project details so that we can provide you the delivery time and cost. we are expert in sql server and complete this task in few Plus

40 $ USD en 1 jour
(0 Commentaires)
0.0
dotnetcrazy1

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

30 $ USD en 1 jour
(0 Commentaires)
0.0
teratechnolab

I am interested to work on this problem. Thanks.

50 $ USD en 1 jour
(0 Commentaires)
0.0