Custom Stored Procedure

Completed Posted Sep 26, 2011 Paid on delivery
Completed Paid on delivery

The goal is to run stored procedure on table1 (input table). Stored Procedure receives two parameters: main variable and variables and their values to create the rows. This is like a cross-tab.

EXEC spCalculation(Model, 'MPG=1, MPG=2, fuelCap=1, fuelCap=2, fuelCap=3')

The input table has three main rows of data, customer_id, VariableName, Value. Goal is to manipulate the table to look like the output example where it has for every value (Ford,Nissan,Jeep,Subaru,etc) in Main Variable two columns. First column is the count of values, second column is percent from that total. Rows represent the values of the string variable sent via parameters.

>>once this project is complete there is a second portion that will be bid out separately but hopefully to the same successful candidate<<

In output table there shouldn't be a limit for rows and columns. The stored procedure must be flexible in handling any amount of rows and columns. This means the main variable can have unlimited values and string variable can have unlimited variables and values.

SQL

Project ID: #1223606

About the project

11 proposals Remote project Active Oct 3, 2011

Awarded to:

chandlerbing

hi, I can provide you with perfect-functioning stored procedure.

$50 USD in 1 day
(4 Reviews)
3.3

11 freelancers are bidding on average $53 for this job

sikandermandal

Please see PMB.

$30 USD in 1 day
(9 Reviews)
4.6
rakib062

Hi, I am working as a database administrator and designer in oracle and ms sql for 4+ years. This is a simple task and can be done within a few hours. I am ready to start. waiting for reply. thanks

$50 USD in 1 day
(6 Reviews)
3.5
hitgon

DBA and Developer

$30 USD in 1 day
(1 Review)
1.0
monica365

Hi, I have experience developing stored procedures in Sql Server. My bid is U$D 30 and the stored procedure will be delivered within one business day. Regards, Monica

$30 USD in 1 day
(0 Reviews)
0.0
awzm

hello , expert here to help you .

$50 USD in 6 days
(0 Reviews)
0.0
romulandarkstar

Hi mike, how are u? I know my long experience with Data Wharehousing and SQL programming are the perfect skills for this job.

$30 USD in 1 day
(0 Reviews)
0.0
ahmad207

Its too simple ...

$30 USD in 1 day
(0 Reviews)
0.0
universalit011

We are ready for proceeding with this project.

$200 USD in 8 days
(0 Reviews)
0.0
sahuarot

****************************** Hello I think it was solved. I'm attaching in PMB a demo screen capture. Please check PMB for more details. I'm MCTS SQL Server 2008 Certified.

$50 USD in 1 day
(0 Reviews)
0.0
Nikhildas

4.4 years experience in sql programming and db design.

$30 USD in 2 days
(0 Reviews)
0.0