Output as SQL

This option formats the output of the query as SQL into a new window. This option allows you to send troubleshooting reports to myDBR support a need to have the table structure and all data to be sent. The SQL output is enough to replicate the troublesome report.

To use the option, open the report in question in SQL Editor and check the report parameters:

Go to "Query 1"-tab and fill in the parameters you wish to use and check the "Output as SQL"-checkbox. Now when you click the "Execute"-button, the report procedure is executed and the output is translated to SQL.

The SQL-output is put into a new "SQL"-tab, where you can copy it to a text document and send it to myDBR support. After this, the support team will be able to execute exactly the same report without your table and data structure.

You can also create the SQL-output directly from the report by adding '&export=sql' to the end of the report URL.