Encerrado

SQL Server 2000 Duplicate Record Question

I need assistance with writting a single SQL script to suppress duplicate records.

The DBMS is SQL Server 2000.

I have attached an Access database with 3 records. The correct result should display two records.

I need to see all columns with the following sort.

[url removed, login to view], CARRIER_TEST.CARRIER_NUM, CARRIER_TEST.CARRIER_CODE, CARRIER_TEST.CARRIER_LIC

The correct result should display only 2 records with correct names. Note: keep in mind this is for SQL Server 2000 not MS Access.

## Deliverables

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

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

Windows, SQL Server 2000

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

Ver mais: ms access sql, SQL Server, sql server c, sql script , loc, dbms, c sql server, keep record access, database question, sql assistance, php sql 2000, windows record, sql question, sql run package, script run access sql, access form record, php windows 2003 server, windows form sql server, install sql script, question form php, writting site, php form sql, sql windows form, access form sql server, access database sql

Acerca do Empregador:
( 68 comentários ) United States

ID do Projeto: #3025019

18 freelancers estão ofertando em média $9 para este trabalho

prabhatsaini

See private message.

$8.5 USD em 1 dia
(147 Comentários)
6.9
justserg

See private message.

$3.4 USD em 1 dia
(143 Comentários)
6.8
TakeRealUK

See private message.

$12.75 USD em 1 dia
(551 Comentários)
6.7
stevewvw

See private message.

$12.75 USD em 1 dia
(103 Comentários)
5.8
aliviu2003

See private message.

$3.4 USD em 1 dia
(48 Comentários)
5.6
skyrma

See private message.

$4.25 USD em 1 dia
(28 Comentários)
5.5
tbishopcnslt

See private message.

$8.5 USD em 1 dia
(25 Comentários)
4.2
tzunivw

See private message.

$4.25 USD em 1 dia
(26 Comentários)
2.9
ivanner

See private message.

$8.5 USD em 1 dia
(5 Comentários)
1.7
mariooch

See private message.

$17 USD em 1 dia
(2 Comentários)
1.6
jvmvw

See private message.

$12.75 USD em 1 dia
(3 Comentários)
1.3
binarybits101

See private message.

$8.5 USD em 1 dia
(2 Comentários)
0.5
sabanayagamj

See private message.

$12.75 USD em 1 dia
(1 Comentário)
0.7
georganoss

See private message.

$3.4 USD em 1 dia
(3 Comentários)
0.0
alphabravoc

See private message.

$3.4 USD em 1 dia
(2 Comentários)
0.0
neosorin

See private message.

$12.75 USD em 1 dia
(1 Comentário)
0.0
maurorodrigues

See private message.

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

See private message.

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

See private message.

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