• mlwiller2 (4/24/2014)


    I am unfamiliar with using join. Is it not possible to modify the code above to just copy all rows?

    Yes it is possible. The problem is that the code you posted does not indicate which row in db2 is related to a row in db1. This is where the join comes into play. It is the logic to know which row is related to which row(s) in another table.

    You should read up on them. Here is a place to start. http://technet.microsoft.com/en-us/library/ms191517%28v=sql.105%29.aspx

    This is fundamental to relational data. If you don't understand this concept you are really going to struggle with things like the update you trying to do.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/