Create a global temp variable to help debug SQL Stuff

MSSQL_GLOBAL_TEMP_DEBUG

if (object_id('tempdb..##RVDEBUG','U') is not null) BEGIN
	drop table ##RVDEBUG;
	PRINT 'DROPPING ##RVDEBUG'
END

IF (object_id('tempdb..##RVDEBUG','U') is null) BEGIN
  CREATE TABLE ##RVDEBUG
   (EventDateTime DATETIME NULL, CallingModule varchar(512) NULL,SysUser VARCHAR(100) NULL,EventDescription varchar(6000) NULL)	
   INSERT INTO ##RVDEBUG VALUES(GETUTCDATE(),'System' ,CURRENT_USER, 'Starting') 
END

DECLARE @paramStart Date = '10/1/2020'
DECLARE @paramMonths int = 12
DECLARE @paramSchedule INT = 900
DECLARE @paramAsset INT = 3
DECLARE @parmRand int = 1
DECLARE @paramFieldDevTeam int = 39538

INSERT INTO ##RVDEBUG VALUES(GETUTCDATE(),'Sample' ,CURRENT_USER,
'@paramStart=' + CONVERT(VARCHAR(255), @paramStart) 
  + ', @paramMonths=' + CONVERT(VARCHAR(255), @paramMonths) 
  + ', @paramSchedule=' + CONVERT(VARCHAR(255), @paramSchedule) 
  + ', @paramAsset=' + CONVERT(VARCHAR(255), @paramAsset) 
  + ', @parmRand=' + CONVERT(VARCHAR(255), @parmRand) 
  + ', @paramFieldDevTeam=' + CONVERT(VARCHAR(255), @paramFieldDevTeam) 
) 

SELECT * FROM ##RVDEBUG;