• How to do nested INSERT EXEC and OUTPUT procedures data into table

    Select a.* Into #TableX From OpenRowset('SQLNCLI',

    'Server=servername;Trusted_Connection=yes',

    'SET FMTONLY OFF; Exec procedure with nested insert exec') As a

    Hope Helpful