[quote=231656:@Patrick Delaney]One thing you could do is write the output clause to a temporary table and read from that in a new statement. That should get you past any scope problems.
temp tables are limited to the connection in hand so it’ll be available so long as the connection is open.[/quote]
found an issue with temp tables a while back:
Summary: Microsoft SQL Plugin crashes when #temp tables are used in a stored procedure and returned to a recordset
Link: <https://xojo.com/issue/34037>