Import SQL Query

In addition to the standard load file and transcript imports, Sanction II also allows you to import SQL queries written by others. Imported queries are added to the Queries tree branch automatically.

An SQL Query file should be in the following format:

Name for the Query (to display) | Full SQL Statement

Be sure to separate the name from the actual SQL statement with a pipe (|) character.

For example, the following query uses some advanced SQL syntax to locate all the pages in certain groups and can be run from the Load Pages By Ex query once imported:

Locate Pages By Ex|SELECT * FROM [DOCUMENTS] WHERE [Group] IN (SELECT [Group] FROM [DOCUMENTS] WHERE [EXHIBITNUM] LIKE '*')

(Note - the query must be a single line and cannot include carriage returns - the above wrapped text is or readability only)