title: UPDATE record in one database with values from another in SQL Server 2008?
body: <p>I need to update my new database with data from 1 column in my old database.  Basically based on matching ItemID's I need to set the Description column in my new DB with the values in the old DB.  I can see what needs to be updated when I do a join but I am not sure how to handle this update properly. </p>