Stored Procedures

Mercury depends upon stored procedures to retrieve data. Your own database developer or administrator should be able to create stored procedures.  And 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 investment.

Mercury can use any stored procedure that returns a tabular result set. Multiple result-sets in one stored procedure for Master/Detail reports are also supported.  Any number of parameters (including none) may be used.  In practice, most stored procedures tend to use between zero and six parameters.

Stored procedures that only return output parameters or a return value are not supported. Return values (if any) with tabular data are ignored.

SQL Tables, Views, and Table-Valued Functions are not supported at this time. Although we have no plans to do so, we will re-evaluate if customers ask for it.

 

Simple Stored Procedure

$ 100 FLAT RATE
  • Requires less than 2 hours Development Time​

Advanced Stored Procedure

$ 200 FLAT RATE
  • Requires less than 2-5 hours Development Time

Custom Estimate

  • Custom estimate required
  • Please contact us for an estimate
  • Email@mercury.co
  • 212-956-7567

Try Mercury for Free

Try Mercury on a fully-functional 14-day trial. Download and install to use with your own data or try Mercury in a remote desktop session using our demo data. 

Try Mercury For Free

  • Download & Install

    Download and install a fully-functional 14-day trial; use it with your own data. (We can help you install and configure).

    System Requirements




  • Over the Internet

    Try PivotViews in a remote desktop session using our demo data; no installation required.

    System Requirements

    None! (Well, you do need a PC that can run Microsoft’s remote-desktop protocol, which includes practically any Windows PC.)