I'm trying to update a column in a temp table, based on a subquery. Brain is blank as to why I can't get the following update to work.<BR><pre class="ip-ubbcode-code ...
this will return: "(1 row(s) affected)" But now I need to know, what data was actually inserted? SQL Server has answered this question in 2005 with the OUTPUT statement: This will return a dataset ...