SQL Table Column Updater

$30-250 USD

Completed

Posted

over 14 years ago

$30-250 USD

Paid on delivery

I need a job for use on a Microsoft SQL Server procedure that will move the data between columns of a table so that: 1. The table to be updated has 90 columns of type "Integer" named "1" through "90" 2. The value in the stored in column "1" of the table is dumped 3. The value in "2" is copied to the "1" 4. The value in "3" is copied to the "2" 5. The process repeats until the value in column "90" is copied to column "89" 6. The value of column "90" is dumped and replaced with 0 The job must be able to run automatically at a set time and must create records in a table to log the start, end and final status (failed/success) of the update. SQL Server Version is SQL Server 2008 Please find the table structure attached.

Microsoft

SQL

Project ID: 601820

About the project

12 proposals

Remote project

Active 14 yrs ago

Looking to make some money?

Email address

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:

@win4t4

I can make a stored proc to do that & then we can make scheduled job to run that stored proc. If you're using a sql server 2008 express edition, I can make a simple application which run that stored proc, cause in express edition you cannot make scheduled task. Winata

$30 USD in 1 day

5.0

(1 review)

1.8

12 freelancers are bidding on average $47 USD for this job

@AlosDeveloper

Hello, please see PMB

$40 USD in 0 day

5.0

(28 reviews)

6.1

@nmppatel

I am an IT professional with 10 yrs experience. I have very good experience developing Stored procedure with SQL Server 2005/2008. I will provide quick & professional service.

$50 USD in 1 day

5.0

(5 reviews)

4.1

@alanding

Sir, please check my PMB!

$35 USD in 1 day

5.0

(2 reviews)

2.0

@kevin100

i will be using SSIS package that can run from SQL Job. SSIS will make this faster, i can do this wil SQL proc if you want.

$40 USD in 1 day

0.0

(0 reviews)

0.0

@engineer200899

script to update the column

$30 USD in 2 days

0.0

(0 reviews)

0.0

@TechiHere

Hi i can do this. Hope we can work together.

$30 USD in 1 day

0.0

(0 reviews)

0.0

@chistybd

I am IT Processional working SQL Server from 6.5. i confident to write any type of store procedure . Trigger, View, Query and other SQL Module

$30 USD in 1 day

0.0

(1 review)

0.0

@CommingSoon

i can do it

$30 USD in 2 days

0.0

(0 reviews)

0.0

@arc01y2k

Hi, I have been in Software Development business since 4 years and have successfully delivered projects for Nordstrom, GAP, Kraft, William-Sonoma. I have also been involved in the development of LMS for Baxter International. Technical capabilities: Microsoft Technologies( VBA, ASP.Net, AJAX, VB.NET, CRYSTAL REPORTS ETC), SQL Server 2000/2005/2008, IIS etc. Estimate and price for the project can be discussed once we are clear with the requirements. Regards, Akash

$150 USD in 2 days

0.0

(0 reviews)

0.0

@ashanker

I am efiicient and do the your job within a very few no of days.

$45 USD in 3 days

0.0

(0 reviews)

0.0

@tahaBestShore

I'm a Senior Software Developer, I did a full database migration project on Microsoft SQL server. I have used TL/SQL and triggers and stored procedures. I will be accurate and committed.

$50 USD in 1 day