I have a stored procedure that is running several different sql statements. All of which are updates or deletes. It is not returning a recordset. I would like to be able to set up some variables with in this sp to store the counts of records that were deleted and updated while it is processing all of the sql statements and then be able to get those variables output after it has processed. How can I do this??