Cancelado

SQL for Insert with Constraints

SQL for Insert with Constraints

Create the Insert Query to populate application tables from import files. The data model has some typical import data cleansing issues like type mismatches, truncations, foreign key constraints, nulls, combined fields to split into two fields (i.e. name spit to firstname and last name). Test data is not available so you would need to be able to create the insert queries from the data model.

This is a very common data cleansing request. You should have the ability to complete this request based on your knowledge of typical file import processes. Specific technical specifications are not available.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

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

SQL Server 2005

Habilidades: .NET, ASP, Programação C#, MySQL, SQL, Visual Basic

Ver mais: insert sql, sql insert, sql coder hire, common query, available hire, test sql server, insert, hire sql, data source sql, data cleansing, cleansing, foreign key, insert form site, sql run package, test sql queries 2008, queries sql, 2008 asp sql, asp insert data, sql coder, create web application sql, sql import files, asp sql server 2005, insert application, desktop sql, sql server 2008 installation

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

ID do Projeto: #3022981

13 freelancers estão ofertando em média $171 para este trabalho

NeoNoXtraOrdnry

See private message.

$46.75 USD em 1 dia
(72 Comentários)
5.4
daccitpvtltd

See private message.

$212.5 USD em 1 dia
(30 Comentários)
5.5
seventhsensesl

See private message.

$40.8 USD em 1 dia
(78 Comentários)
5.0
abcdefghivw

See private message.

$63.75 USD em 1 dia
(6 Comentários)
4.3
syedtariqvw

See private message.

$126.65 USD em 1 dia
(16 Comentários)
4.0
lemoinek

See private message.

$25.5 USD em 1 dia
(7 Comentários)
3.5
cybersagetechvw

See private message.

$322.15 USD em 1 dia
(3 Comentários)
2.6
premiummethods

See private message.

$3.4 USD em 1 dia
(3 Comentários)
0.9
hrvatvw

See private message.

$170 USD em 1 dia
(0 Comentários)
0.0
ashmeth

See private message.

$238 USD em 1 dia
(0 Comentários)
0.0
stephenfourie

See private message.

$595 USD em 1 dia
(0 Comentários)
0.0
jakeebbie

See private message.

$42.5 USD em 1 dia
(0 Comentários)
0.0
berkaysvw

See private message.

$340 USD em 1 dia
(0 Comentários)
0.0