Skip to main content

Testing the Stored Procedure

The stored procedure can be tested using a specific 'StartTime' and 'EndTime'.

The following figure provides an example query for testing the stored procedure.Figure 1169: Example of a query to test the stored procedure

The results produced from the query example in Figure 1169 would look like the following figure:Figure 1170: Stored procedure test results

In Figure 1170, note that:

  • Filtering is from Jan-01-2015 to Jan-02-2015.
  • We get 12 rows for the specific CASE.
  • We now have a Stored Procedure that can be used in a Report for SSRS.