Trouble viewing images? Click on images to enlarge.

In this article we cover how to leverage a stored procedure inside VDM.

What Are Stored Procedures?

Stored procedures are prepared SQL code that you can save, so the code can be reused over and over again. If you have a SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it.

You can also pass parameters to a stored procedure, so that the stored procedure can act based on the parameter value(s) passed.

Calling Stored Procedures

1. Open VDM and click on Advanced Query.

2. Create the call for the stored procedure. See example below for structure.

Structure: {CALL Stored Procedure(Parameters)}

Example: {CALL rmb_view.AccountRepScorecard_ByUser(?StartDate?, ?EndDate?, ?UserID?)}

3. Execute the stored procedure and verify results.

4. Save the View.