Modify stored procedure in MSSQL

In Progress Posted Mar 3, 2015 Paid on delivery
In Progress Paid on delivery

I have a stored procedure written that updates some table fields in my database, what I need is the stored procedure modified so that if

@lowestsupplierID > 0 then do what its currently doing

but if @lowestsupplierID = 0 then run a different update equation.

I can write the different equation, what I dont know how to do is get the @lowestsupplierID to carry over from a previous stored procedure into this stored procedure so I can adjust the different equation.

You can either remote connect into the server to make the modification or I can email it to you. It should be a very simple project for someone who knows what their doing, a few minutes really.

Microsoft SQL Server

Project ID: #7241452

About the project

4 proposals Remote project Active Mar 3, 2015

Awarded to:

jebloom

This is a really simple change to your existing TSQL script. What you really need to do is just execute the other stored procedure passing a variable as a parameter.

$25 USD in 1 day
(1 Review)
1.6

4 freelancers are bidding on average $21 for this job

Neno585

Hello, I am an SQL Server and Oracle developer so this might be a fairly simple task for me, if you want my help, feel free to contact me, as we are in different time zones you could send me the details by mail if you More

$20 USD in 1 day
(22 Reviews)
7.0
dank23

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0