Find Jobs
Hire Freelancers

Modify stored procedure in MSSQL

$10-30 USD

In Progress
Posted about 9 years ago

$10-30 USD

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.
Project ID: 7241452

About the project

4 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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
5.0 (1 review)
1.6
1.6
4 freelancers are bidding on average $21 USD for this job
User Avatar
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 day
5.0 (22 reviews)
7.0
7.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Boardman, United States
5.0
7
Payment method verified
Member since Nov 27, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.