DECLARE @SERVICE_ID INT
INSERT INTO [CMAS].[UTIL].[SERVICE_CONTROL]
([SOURCE_TABLE]
,[REQUEST_STORE_TM]
,[INFERRED_MATCH_STATUS]
,[SERVICE_TYPE])
VALUES
('LPDR.SERVICER'
,GETDATE()
,'R'
,0)
SET @SERVICE_ID = @@IDENTITY
SELECT @SERVICE_ID AS '@SERVICE_ID'
update lpdr.SERVICER_INFERRED_MATCH_STAT set INFERRED_MATCH_STAT = 'R', SERVICE_ID = @SERVICE_ID
GO
--SELECT * fROM [CMAS].[UTIL].[SERVICE_CONTROL] WHERE INFERRED_MATCH_STATUS = 'R'