Đã hoàn thành

SQL/Access Database Matching/Duplicate Finder

Attached please find a Access Database with one two tables inside. The first is entitled FilteredData. The second is Mapping-New. The first table (FilteredData) is the table of which I want a duplicate search performed on. The original file should stay intact. And, the code you create should be fully portable from Access to SQL and vice versa. We will call the duplicate/non-duplicate search PhaseI so to speak, which again requires the creation of a working/portable code that will find all duplicates within the original table (the FilteredData table). Exact matches on all columns are considered duplicates and should be place in a new table called duplicates. All non-duplicates should be placed in a new table called non-duplicates. A test of the data integrity should prove that the duplicate and non-duplicate table record counts tie back to the original table (the FilteredData table) . PhaseII of which may require me to request a new bid or just forward a bonus to you depending on your preference is not too different from PhaseI. In PhaseII I need to find all exact matches from FilteredData table the column with the heading PolicyNumFirst9 to Mapping-New table with the column heading Pol Pfx and Serial. All exact matches should be placed in a table called FilteredToMappedMatched and all unmatched should be placed in a table called FilteredToMappedUnmatched. And, again those two table should tie out to the original table. I have attached a Query within the database that should give you a better idea of what I am attempting to do however, it this query is not tieing out. Hence, my need of your skills. As a reminder, I need working/portable code and I also need a quick turnaround and as a result I will be giving performance based bonuses for this project. If you have any questions let me know. Thanks.

## Deliverables

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

## Platform

windows 2000

## Deadline information

I am looking for a exceptionally quick turnaround on this. Which means I am willing to be more than generous in relation to a performance bonus. However, I must stress that the code has to be portable, proven and streamlined.

Kĩ năng: Quản trị cơ sở dữ liệu, Kĩ thuật, MySQL, PHP, Kiến trúc phần mềm, Kiểm tra phần mềm, SQL, Visual Basic

Xem nhiều hơn: duplicate finder access sql, work finder, what is on the prove it test, test prove it questions, test data creation, my sql create database, find duplicates sql, database skills, sql duplicates, sql and c, SQL Access, query creation, pol, out source a database, matching platform, database performance , data source sql, c# with access database, c with access database, access to sql

Về Bên Thuê:
( 9 nhận xét ) United States

ID dự án: #2866287

Được trao cho:

curtisrsummers

See private message.

$102 USD trong 14 ngày
(4 Đánh Giá)
2.8

34 freelancer đang chào giá trung bình $142 cho công việc này

DenKar

See private message.

$85 USD trong 14 ngày
(91 Nhận xét)
6.4
vstarvw

See private message.

$106.25 USD trong 14 ngày
(12 Nhận xét)
5.8
southerndev

See private message.

$85 USD trong 14 ngày
(64 Nhận xét)
5.3
ameentj

See private message.

$170 USD trong 14 ngày
(42 Nhận xét)
5.1
randymvw

See private message.

$170 USD trong 14 ngày
(8 Nhận xét)
5.2
timcookinte

See private message.

$212.5 USD trong 14 ngày
(2 Nhận xét)
4.5
eeevren

See private message.

$85 USD trong 14 ngày
(27 Nhận xét)
4.4
ziran

See private message.

$85 USD trong 14 ngày
(47 Nhận xét)
4.5
alokgarg

See private message.

$85 USD trong 14 ngày
(69 Nhận xét)
4.2
gammavw

See private message.

$85 USD trong 14 ngày
(10 Nhận xét)
4.2
prosolutionsvw

See private message.

$255 USD trong 14 ngày
(4 Nhận xét)
3.7
ENCMediaWorks

See private message.

$85 USD trong 14 ngày
(10 Nhận xét)
3.8
genesisinternet

See private message.

$212.5 USD trong 14 ngày
(5 Nhận xét)
3.2
juancarlospazos

See private message.

$212.5 USD trong 14 ngày
(21 Nhận xét)
4.4
sfriendvw

See private message.

$85 USD trong 14 ngày
(1 Nhận xét)
2.8
vw367987vw

See private message.

$85 USD trong 14 ngày
(3 Nhận xét)
2.7
3lun0

See private message.

$340 USD trong 14 ngày
(1 Nhận xét)
2.4
subhashjivw

See private message.

$85.85 USD trong 14 ngày
(5 Nhận xét)
2.4
msmking

See private message.

$102 USD trong 14 ngày
(2 Nhận xét)
2.1
stephanevergier

See private message.

$85 USD trong 14 ngày
(2 Nhận xét)
1.3