If your company uses SQL databases, then Mercury relies on stored procedures, views, or SQL statements for data retrieval. (Depending on your SQL platform, stored procedures may not be available.)

Your own database developer or administrator should be able to create stored procedures and views, or provide you with the proper SQL statements. (Or you may be comfortable doing this yourself). Also, your software reseller/VAR should have a developer on staff or on contract. These are your best choices because they will already have a good understanding of the databases in use at your site.

However, we will provide development services at a modest cost to help you get the most out of your Mercury subscription.

Mercury can use any query that returns a tabular result set. Multiple result-sets for use in Master/Detail reports are also supported.

Regarding stored procedures in particular:

• Any output other than the result-set(s) — e.g. a return code, or an output parameter — is ignored.
• Any number of formal parameters (including none) may be used. In practice, most stored procedures tend to use between zero and six parameters.