DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

ALTER FUNCTION [dbo].[FN_GET_ACC_NAME_PAY](@p_ACC_NO varchar(100))

	returns nvarchar(500)

AS

BEGIN

	-- LUCTV 03062020 BO BANG ACCOUNT BAO GOM ACCOUNT VA ACCOUNT PAY

	DECLARE  @TABLE_ACCOUNT TABLE (ACC_NO VARCHAR(100), ACC_NAME VARCHAR(1000))

	INSERT INTO @TABLE_ACCOUNT SELECT ACC_NO, ACC_NAME FROM CM_ACCOUNT

	--INSERT INTO @TABLE_ACCOUNT SELECT ACC_NUM, ACC_NAME FROM CM_ACCOUNT_PAY

	--INSERT INTO @TABLE_ACCOUNT SELECT ACC_NUM, ACC_NAME FROM CM_SUPPLIER

	--INSERT INTO @TABLE_ACCOUNT SELECT ACC_NUM_OUT, ACC_NAME_OUT FROM CM_SUPPLIER

	---

	declare @l_ACC_NAME nvarchar(500)		

	SELECT @l_ACC_NAME = ACC_NAME FROM @TABLE_ACCOUNT WHERE ACC_NO = @p_ACC_NO

	--IF LEN(@p_ACC_NO) > 9

	--BEGIN 

	--	SELECT @l_ACC_NAME = DAO_NAME FROM CM_BRANCH WHERE DAO_CODE = @p_ACC_NO

	--END	

	--ELSE

	--BEGIN

	--END

	RETURN @l_ACC_NAME

END