In a SQL Server 2008 environment, I have two tables with the following structure.
Table2.ID corresponds to Table1.DescriptionID. However, I am no longer in need of it. I want to perform a bulk update to change the value of Table1's Description field to the same value in Table2. In other words, I wish to take the following action:
[Description]=(SELECT [Description] FROM [Table2] t2 WHERE t2.[ID]=Table1.DescriptionID)
However, I'm not sure if this is the appropriate approach. Can someone show me how to do this?