Concluído

SQL Routine

**SQL Routine for MS SQL Server - Description:**

Overview: Loop through a SQL table and conditionally write values to other tables.

The attachment contains full decsription of the required routine plus SQL script for generating the tables and an Excel data file for test data.

Import the Excel file [[url removed, login to view]] into MS SQL. It will import as **Sheet1$**.

Loop through records in **Sheet1$**table and read/insert the data into **exp_invoice,** **inc_deposit, well, purchaser, operator** tables according to the rules described in the routine.

## Deliverables

1) SQL script either a store procedure or funciton that can be run in Enterprise Manager.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Microsoft SQL Server 2000

Habilidades: Engenharia, MySQL, PHP, Arquitetura de software, Teste de Software, SQL

Veja mais: sql coder for hire, purchaser required, hire a sql coder, engineering manager, data coder operator, microsoft test manager, microsoft excel test, test sql server, sql script , sql microsoft, sql import, MICROSOFT SQL SERVER, import sql, hire sql, excel to sql, sql server attachment, script php file manager, php import data xls, sql required, php sql 2000

Acerca do Empregador:
( 193 comentários ) Dallas, United States

ID do Projeto: #3127496

Concedido a:

TakeReal

See private message.

$85 USD em 2 dias
(1269 Comentários)
7.5

9 freelancers estão ofertando em média $109 para esse trabalho

psergei

See private message.

$153 USD in 2 dias
(449 Comentários)
8.6
springdotnetvw

See private message.

$85 USD in 2 dias
(137 Comentários)
7.2
andrewjdvw

See private message.

$85 USD in 2 dias
(47 Comentários)
5.3
omiossec

See private message.

$170 USD in 2 dias
(15 Comentários)
4.7
mysticsvw

See private message.

$127.5 USD in 2 dias
(3 Comentários)
3.5
vw1135462vw

See private message.

$89.25 USD in 2 dias
(7 Comentários)
3.3
wackevw

See private message.

$102 USD in 2 dias
(10 Comentários)
3.3
magnusp

See private message.

$85 USD in 2 dias
(6 Comentários)
1.9