Re: Stored Procedure to return resultset from multiple delete statements.

On Tuesday, August 4, 2015, Jason Aleski <jason(dot)aleski(at)gmail(dot)com> wrote:

> I have a function that will purge an item out of our inventory system.
> This script works and displays the appropriate information in the
> messages/notices pane. I would like it to return the notices in a
> resultset format because only developers have access to the
> messages/notices pane. I would like to display the results as a resultset
> in my application. The problem is that I'm issuing multiple delete
> commands which cannot be joined. I tried creating a temp table at the top
> of the procedure, then inserted data (rows affected) into the table; but I
> could not get that method to work. Can anyone point me in a direction on
> what to look at to get the "table affected" and the "number of rows
> affected by the delete" into some sort of result set? Below is my current
> procedure that is working. There are actually 3 more tables that need to
> be purged, but I removed those for now.
>
>
>
Your solution will most easily be accomplished using a combination of
"delete ... returning", insert, and cte/with.

David J.