If @action='Save' or @action='Submit' then the procedure will add the data to the SSMC_EPMT.dbo.EPMT_TBL_REQUEST table
😎
Suggest you generate some sample data in order to make your ,net code work,...

Out of curiosity, why duplicate the results?
😎

You could do something like this
DECLARE @x XML = '<revieves>
<recievemessages>
  <message>test</message>
  <to>111111</to>

The function is executed by this line of code in the procedure
😎

set @NStatusID =dbo.ePMT_findStatus(@action, @status)

First thought would be to delete from the sysjobhistory table and use the output clause to archive the entries, no risk of any duplication.
😎

DECLARE...

Quick question, what is the divisor ct in your TotAvg calculation?
😎

((Jan2016t + Feb2016t + Mar2016t + Apr2016t + May2016t + Jun2016t + Jul2016t +...

Here is a quick suggestion towards a solution that should get you passed this hurdle
😎

USE TEEST;
GO
SET NOCOUNT ON;
--https://www.sqlservercentral.com/Forums/1856286/Defferance-Count-days-within-one-year
IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATE') IS...

Back in the old days I was managing several mission critical database servers using GSM Data / GPRS, SSH and Putty on this device
😎

Must admit...