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.
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).
Windows, SQL Server 2000