In Progress

SQL Table Column Updater

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.

Skills: Microsoft, SQL

See more: table data structure, process data structure, sql server job, time table, table, sql microsoft, move sql, microsoft sql server, column, sql final, sql move data, server sql, stored procedure create sql, sql stored, sql microsoft 2008, sql update, value table, sql job, job sql, job microsoft, sql table update data, create table sql server, sql server create table, status updater, updater

About the Employer:
( 20 reviews ) Christ Church, Barbados

Project ID: #601820

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 expr More

$30 USD in 1 day
(1 Review)
1.8

12 freelancers are bidding on average $47 for this job

AlosDeveloper

Hello, please see PMB

$40 USD in 0 days
(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 Reviews)
4.1
alanding

Sir, please check my PMB!

$35 USD in 1 day
(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 Reviews)
0.0
engineer200899

script to update the column

$30 USD in 2 days
(0 Reviews)
0.0
TechiHere

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

$30 USD in 1 day
(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
(1 Review)
0.0
CommingSoon

i can do it

$30 USD in 2 days
(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 Interna More

$150 USD in 2 days
(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 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
(0 Reviews)
0.0