Custom Stored Procedure
$30-250 USD
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.
Project ID: #1223606
About the project
Awarded to:
11 freelancers are bidding on average $53 for this job
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
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
Hi mike, how are u? I know my long experience with Data Wharehousing and SQL programming are the perfect skills for this job.
****************************** 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.