check_entries_tocore.txt
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 |
|