- Two tables: tData, tData2
- Exactly the same columns
- About 200,000 records
- SQL Server 2008 R2
At first sight we need to insert tData rows into tData2. What else?
We need a renamed version of a column inside another (tData2) with the condition checking it won't be an existing item when it's renamed. Here's the code:
INSERT INTO [tData2] ( [Key], Info1, Info2 ) SELECT REPLACE([Key],'_',' '), Info1, Info2 FROM [tData] WHERE (REPLACE([Key],'_',' ') = [Key]) OR (REPLACE([Key],'_',' ') NOT IN (SELECT [Key] FROM [tData]))
The problem is it's really slow for me on a top-notch 64 bit system. It has taken more than an hour so far and it's still executing.
How to speed it up? Any alternatives? Any ideas?