Modify stored procedure in MSSQL

En curso Publicado Mar 3, 2015 Pagado a la entrega
En curso Pagado a la entrega

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.

Servidor de Microsoft SQL

Nº del proyecto: #7241452

Sobre el proyecto

4 propuestas Proyecto remoto Activo Mar 3, 2015

Adjudicado a:

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 en 1 día
(1 comentario)
1.6

4 freelancers están ofertando un promedio de $21 por este trabajo

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 Más

$20 USD en 1 día
(22 comentarios)
7.0
dank23

A proposal has not yet been provided

$25 USD en 1 día
(0 comentarios)
0.0