Data Cleaning Background: I have a SQL Server 2000 database table with almost 750,000 records. Here is the structure of the table: CREATE TABLE Restaurant ( RestaurantID INT NOT NULL IDENTITY( 1, 1 ) PRIMARY KEY, Name VARCHAR( 255 ) NULL, Street VARCHAR( 255 ) NULL, City VARCHAR( 255 ) NULL, ProvState VARCHAR( 255 ) NULL, ZipPostal VARCHAR( 255 ) NULL, Phone VARCHAR( 255 ) NULL, Remove BIT NOT NULL DEFAULT( 0 ) ) GO Tasks: I need a T-SQL script that will update the “Remove?? field for any record with the following criteria: > Tag duplicates: if there are 2 or more records that have the same ZipPostal AND Phone, update all but one of the duplicates’ “Remove?? field to true (1) > Tag with name match: update all records’ “Remove?? field to true (1) with the word “office?? in the name field ??" the word may occur at the beginning, middle, end or any part of name field Additional Requirements: With the size of the table (750K records), I would like to have the script as efficient as possible as this will need to be executed on the production server. With your bid, please let me know how you plan to build this script and how long you would expect the script to take to execute on a table with 750K records. Please provide your best bid, as I would like to get started on this as soon as possible.
## 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
Windows XP Pro SQL Server 2000 Microsoft SQL Server Management Studio Express