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

We are using SQL server 2008R2

Skills: SQL

See more: sql update script, sql update script append number, sql update script excel, script sql update, sql price, sql create table price, sale codes, exceed database, update using sql excel, t-sql with, t-sql in, sql r, sql in r, r sql, t-sql;, stock update, sql script , Sql code, sql based, notation, excel to sql, sql update text, database copy script, sql update field text, update sql file

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

Project ID: #1257191

Awarded to:


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

$50 USD in 1 day
(15 Reviews)

2 freelancers are bidding on average $75 for this job


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

$100 USD in 1 day
(2 Reviews)

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

$120 USD in 3 days
(0 Reviews)