In Bearbeitung

Modify stored procedure in MSSQL

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.

Fähigkeiten: Microsoft SQL Server

Mehr darüber stored, mssql remote database, connect sql server remote, mssql procedure, database procedure, modify procedure, project mssql server, stored procedure mssql, write stored procedure sql, mssql email, modify fields sql, mssql execute stored procedure min, mssql etl stored procedure, mssql 2005 stored procedure, script mssql 2005 stored procedure, mssql copy stored procedure, stored procedure copy data sql server, mssql writing stored procedure, update write sql, SQL STORED PROCEDURE, mssql executing stored procedure regularly, mssql xml stored procedure, mssql script stored procedure, update stored procedure

Über den Arbeitgeber:
( 7 Bewertungen ) Boardman, United States

Projekt-ID: #7241452

Vergeben an:

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 Tag
(1 Bewertung)
1.6

4 Freelancer bieten im Durchschnitt $21 für diesen 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 Mehr

$20 USD in 1 Tag
(22 Bewertungen)
7.0
thesaw

Hello sir, i am a good experience .NET ( Desktop Application and Web Application ) using MVC and Webforms also have experience on JQuery and JQuery AJAX , bootstrap and another technology. just give me that chance Mehr

$15 USD in 1 Tag
(1 Bewertung)
1.0
dank23

A proposal has not yet been provided

$25 USD in 1 Tag
(0 Bewertungen)
0.0