Problem
The figure displayed in Sales This Month are for the first month of the year not the current logged in month. In the screen shot, the Sales This Month are in respect of July 19 not February 2020.
Correct results after applying the updated stored procedure
Solution
SQL skills required
A working knowledge of SQL Management Studio is required to complete this task.
Corrected stored procedure is attached. Download and run the SQL script to correct the results returned.
Related articles