I'm looking for the BEST WAY based on performance to reinsert all records from one table to another table only changing the values of one column.. My initial thought is to create a temp table and put the results of my query in that and then update the column and then insert the data back into the original table.. Would this be the best way?
Microsoft SQL Server 2005Microsoft SQL Server 2008SQL
8/22/2022 - Mon
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.