Project

General

Profile

Download (180 Bytes)

UPD_TR_REQ_ADVANCE_SEARCH.txt

Luc Tran Van, 10/16/2022 12:06 PM

 
1 
IF(NOT EXISTS (SELECT * FROM CM_BRANCH WHERE BRANCH_ID = @p_BRANCH_ID))
2 
	BEGIN
3 
		SET @p_BRANCH_ID = (SELECT TOP 1 BRANCH_ID FROM CM_BRANCH WHERE BRANCH_CODE = @p_BRANCH_ID)
4 
	END