SQL 2008 SP3+ and above (and probably below) supports multiple OUTPUT statements, as long as the first one is OUTPUT INTO and the second is OUTPUT...
These statements are nice to allow OUTPUT INTO a table variable/temp table for further operations, and to OUTPUT to return a result set to the user (SSMS or data layer).
The following TSQL is valid and executes, but SQL Prompt 188.8.131.52 will not format throws the message "SQL Prompt was unable to complete this operation. Problem areas have been highlighted."
FROM ( VALUES ( 0) ) AS tbl (fld)
--Deletes from #Tbl
--Returns #Tbl as a ResultSet
--Inserts back it into #Tbl
DELETE FROM #Tbl