I ran this query in the Query Analyzer for 6 hours and then gave up. 29 million recs at 24GB.
Update A
Set Acctid = B.Acctid
From B
Where Substring(VendId,5,4) = B.VendId4
I did a link from Access and Access took 4 Hrs but it worked for 5,3.
Any suggestions will help me understand the SQL system.
