Modify stored procedure in MSSQL

$10-30 USD

In corso

Pubblicato

circa 9 anni fa

$10-30 USD

Pagato al completamento

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

Rif. progetto: 7241452

Info sul progetto

4 proposte

Progetto a distanza

Attivo 9 anni fa

Hai voglia di guadagnare un po'?

Indirizzo Email

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze

Fatti pagare per il lavoro svolto

Delinea la tua proposta

La registrazione e le offerte sui lavori sono gratuite

Assegnato 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 in 1 giorno

5,0

(1 valutazione)

1,6

4 freelance hanno fatto un'offerta media di $21 USD

@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 decide to consider me. Anyway, thank you for consideration and good luck with your problem :)

$20 USD in 1 giorno