I am having two tables in the SQL Server 2008 with the below structure:
Table1.DescriptionID maps to the Table2.ID. But, I don't want that any more. I need to be doing a bulk update to set the Description property of Table1 to the value associated with it in Table2. In other words, I need to be doing something like this:
[Description]=(SELECT [Description] FROM [Table2] t2 WHERE t2.[ID]=Table1.DescriptionID)
Can anyone guide me on how to do it.