mlwiller2 (4/24/2014)
It looks like I need to have some kind of ID column on each table. I might have to adjust some of the other code since right now the tables get completely truncated every time the query is ran, which would remove the ID values.
You don't necessarily need to have an ID column but you should have a primary key on both tables. It sounds like whatever you are doing is part of a larger process. It is nearly impossible to help much because we don't really have any details to work with.
_______________________________________________________________
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/