ASP and SQL Queries needed

Completed Posted Apr 6, 2007 Paid on delivery
Completed Paid on delivery

I have an application that records miles and modes of transportation. with the following Database table called Activity in MS SQL

Here is the table properties and fields

ActivityID int Unchecked

UserID nvarchar(50)

Activity nvarchar(255)

Options nvarchar(50)

Miles float

There is a second table called Options with the following records below. The Option field is what is recorded in the Options Field in the Activity Table:

OptionID Option

1 Bike

2 Walk

3 Bus

4 Carpool

5 Work From Home

6 Combine Trips

What I need to be able to do is show the individual user (the UserID) how they rank with other users.

Most miles biked

Most miles walked

Most miles Bused

Most miles carpooling

Most Miles worked from Home

Most Miles with Combined trips

Most miles not driven (total of all modes used above)

I need to be able to give a rank to the individual user of how their activities (from the Activities table) rank with the other users.

The trick here is that we have to rank everyone by their UserID to give us the ranking then tell the user based on their activities how they rank with everyone else in each Option. They would get a rank (a placement number from 1 to the total number of UserIDs for each. The last one being the ranking of the total combined miles.

## Deliverables

I develop in ASP so I would need the SQL and the appropriate ASP call to get the data to display (AKA [url removed, login to view] XXXX)

Please don't ask me if I want to do it in ASP.NET the application is already done and I am only adding to it.

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

ASP (VB Script) and MS Sql

ASP Engineering MySQL PHP Software Architecture Software Testing SQL

Project ID: #2913875

About the project

11 proposals Remote project Active Apr 9, 2007

Awarded to:

precept

See private message.

$17 USD in 3 days
(26 Reviews)
3.5

11 freelancers are bidding on average $58 for this job

peregrinus

See private message.

$12.75 USD in 3 days
(126 Reviews)
5.9
baburam

See private message.

$68 USD in 3 days
(86 Reviews)
5.1
californianative

See private message.

$63.75 USD in 3 days
(35 Reviews)
4.6
appliquertech

See private message.

$85 USD in 3 days
(14 Reviews)
4.5
philmanningvw

See private message.

$29.75 USD in 3 days
(10 Reviews)
3.1
hoodhali

See private message.

$25.5 USD in 3 days
(9 Reviews)
3.0
teddycarebears

See private message.

$42.5 USD in 3 days
(8 Reviews)
2.5
designzvw

See private message.

$102 USD in 3 days
(3 Reviews)
0.0
aengula

See private message.

$63.75 USD in 3 days
(0 Reviews)
0.0
ehrithik

See private message.

$55.25 USD in 3 days
(0 Reviews)
0.0
RockyM

See private message.

$85 USD in 3 days
(0 Reviews)
0.0