Comments posted to this topic are about the item Using temporary tables with OUTPUT clause
Nice, easy question to end the week on, thanks Junior
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
4*2 = 8
Hall of Fame
Same thing here.
One Orange Chip
The INSERT produces a "(4 row(s) affected)" message, so does the UPDATE.
Since nothing produced a "(8 row(s) affected)" message, I assumed the question only applied to the result of the UPDATE. The question could have been worded better to make that clear, but "(4 row(s) affected)" is the only valid answer.
Hall of Fame
Assumptions do Not Always lead to mistakes, but Most Mistakes are Caused by Assumptions. My personal experience, begins with DOS 3. 🙂
Wasn't sure which answer would be correct as I knew it would return 4 row(s) affected twice and I guessed incorrectly.
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/
Viewing 7 posts - 1 through 6 (of 6 total)