OK SQL Gurus, this one is for you. The problem:
I have three tables of data which need to be updated each month with new data in a SQL 7.0 database. All the delimited text files to be imported have the same schema as the tables of data that need to be updated although the field names are slightly different. Table one has a primary key and about 30 columns of data. The data being imported has matching primary keys. All you need to do in this case is write over the entire table. There are, on average, about 35,000 records in this table. Table two relates to table one. And the key is the same. And again, all you have to do is write over the existing data. There are about 9,000 records in this table. Table three is the hard one. This table has 15 columns and NO primary key. There are about 85,000 records. For each row of data to be imported, you must compare all 15 columns of data against all 15 columns of data for all 85,000 records to see if there is a match first, and if not, then import the new data. The solution need not be limited to ColdFusion templates. I am open to other suggestions. For example, you might want to write this update procedure with stored procedures inside the SQL 7.0 database. Or you might want to use ASP or PERL to do the job. Whatever works is fine with us. Please submit a fixed-fee bid for this work. I will evaluate the suggestions and respond to the most appropriate bidder. ---mark Fusioneers.com __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_jobs or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
