Getting back the Rows involved from Advanced Query

Getting back the Rows involved from Advanced Query

  
Is it possible to get back the rows involved, after using a DELETE or UPDATE statement in the Advanced Query? It is not possible to use the T-SQL "SELECT @@ROWCOUNT;" statement, this gives an error 'unknown variable' or 'unknown column'
Hi Matthias,

Try using the value "@@ROWCOUNT" in a parameter with 'Expand Inline' = Yes.
Ok, that did work, created the variable @StrRowCount, with INLINE set to YES, and the value "@@ROWCOUNT",
and set the Adv. Query statement to:

DELETE FROM {Contact}
WHERE {Contact}.[Valid] = 0;

SELECT @StrRowCount

Thanks for the quick response,

Matthias Preuter