beb9021 (3/1/2013)
Hello RP_DBA.. I tried your method. However, in the message box I am getting this error message:Msg 208, Level 16, State 1, Line 1Invalid object name 'Table_1'.
Is there a step that I am missing. I also faied to mention i am using SQL 2008 R2.
Thanks
What you are missing is that he assumed that you already had tables named Table_1 and Table_2 based on your initial post. He did not build a test environment like I did with my code.