I need to update table 1 which is missing few rows from table 2 (is on another database on the same instance). What would be a good way of importing the data from table 2 to table 1 in SQL Server 2005.
closed as off topic by voretaq7♦ Sep 10 '12 at 22:02
Questions on Server Fault are expected to relate to professional server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.