Project

General

Profile

check_entries_tocore.txt

Luc Tran Van, 07/22/2022 11:39 AM

 
1
ALTER PROC [dbo].[MW_IN_Retry_Entries_ToCore]
2
@p_TRN_ID varchar(15) = NULL
3
AS
4
BEGIN
5
	
6
	IF(EXISTS(SELECT A.* FROM MW_ENTRIES_POST A WHERE A.TRN_ID = @p_TRN_ID AND (A.REF_NO IS NULL OR A.REF_NO = '')))
7
	BEGIN
8
		SELECT '-1' as Result, ''  LOG_ID , N'Các bút toán bắn vào core thất bại' ErrorDesc
9
		RETURN '-1'
10
	END
11
	ELSE
12
	BEGIN
13
		SELECT '0' as Result, ''  LOG_ID ,'' ErrorDesc
14
		RETURN '0'
15
	END
16
END
17