I chose 4, but (as it turns out) I was guessing. (I thought I knew what was going on, chose an answer and clicked 'Submit' before actually studying the question -- yes, that's a problem I'm working on)
After re-reading the explanation, as well as all of the posts in this thread, I'm not clear on what is happening exactly.
As a Rookie, this is what I *think* is happening:
1. Temp table is created
2. 10 records are created in temp table
3. 4 More records are added to temp table (first part of @sql_str)
4. All records are deleted from temp table (second part of @sql_str)
Obviously, that is not the case. I can't find anything in BOL to help figger this out. Any help?
Thanks in advance,
- Joseph Marsh
Thanks,
- Joseph Marsh