SQL Table Column Updater

$30-250 USD

Concluído

Publicado

há mais de 14 anos

$30-250 USD

Pago na entrega

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

ID do Projeto: 601820

Sobre o projeto

12 propostas

Projeto remoto

Ativo há 14 anos

Quer ganhar algum dinheiro?

Endereço de e-mail

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo

Seja pago pelo seu trabalho

Descreva sua proposta

É grátis para se inscrever e fazer ofertas em trabalhos

Concedido a:

@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 em 1 dia

5,0

(1 avaliação)

1,8

12 freelancers estão ofertando em média $47 USD for esse trabalho

@AlosDeveloper

Hello, please see PMB

$40 USD em 0 dia

5,0

(28 avaliações)

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 em 1 dia

5,0

(5 avaliações)

4,1

@alanding

Sir, please check my PMB!

$35 USD em 1 dia

5,0

(2 avaliações)

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 em 1 dia

0,0

(0 avaliações)

0,0

@engineer200899

script to update the column

$30 USD em 2 dias

0,0

(0 avaliações)

0,0

@TechiHere

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

$30 USD em 1 dia

0,0

(0 avaliações)

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 em 1 dia

0,0

(1 avaliação)

0,0

@CommingSoon

i can do it

$30 USD em 2 dias

0,0

(0 avaliações)

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 em 2 dias

0,0

(0 avaliações)

0,0

@ashanker

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

$45 USD em 3 dias

0,0

(0 avaliações)

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 em 1 dia