In Progress

SQL UPDATE script needed

I need some to write an update sql script

We will be Taking an excel file with the following 3 columns

Number,Class Code, Sale Price

and it will need to make the following changes to our database and tables

stock Table

Where Excel Number column = [url removed, login to view] field

Copy the [url removed, login to view] field to [url removed, login to view] then replace [url removed, login to view] with Sale value from excel file.

Append the following text to [url removed, login to view] field "DISCONTINUE ITEM" makeing sure that new notation field doesn't exceed 60 characters

Create a new record in SL_PROD using excel number for [url removed, login to view], For [url removed, login to view] it will be one of several different codes based on which Class Code is in excel file (Possible Class codes are R,S,C,DV,DA,X,A), two remaining fields just use the next value which would be Disp_SEQ and SL_PROD_ID

Skills: SQL

See more: sql update script, sql update script excel, script sql update, sql price, sql create table price, sale codes, exceed database, update using sql excel, sql r, r sql, stock update, sql script , sql code, sql based, notation, sql update text, database copy script, sql update field text, update sql file, update stock, sql different, update code sql, sql create script, update text sql, excel column update

About the Employer:
( 1 review ) Anderson, United States

Project ID: #1257191

Awarded to:

HussienSharaf

HI, I can do this script in 2 hrs. Hussien Sharaf

$50 USD in 1 day
(15 Reviews)
6.6

3 freelancers are bidding on average $90 for this job

ezzarghili

Dear sir, It can be done. Right bidder here.

$100 USD in 1 day
(2 Reviews)
3.2
junbest1986

Dear Sir, I am willing to do the project, I am a computer programmer since 2008. Thanks

$120 USD in 3 days
(0 Reviews)
0.0