What are the challenges you face when working across database platforms? Take the survey

Multiple OUTPUT statements not supported by SQL Prompt 6.1

chrisw13chrisw13 Posts: 6 Bronze 2
edited November 7, 2013 4:27AM in SQL Prompt
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 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


  • Options
    Thank you for reporting this issue to us.
    I was able to reproduce the behavior and have logged this issue in our bug tracking system under the internal reference number of SP-4910.
    Unfortunately I am unable to provide a timeline for when this may be fixed.
    Manfred Castro
    Product Support
    Red Gate Software
  • Options
    Aaron LAaron L Posts: 596 New member
    The second output clause should now be supported in the latest release (
Sign In or Register to comment.