AMS - VB

ALTER PROCEDURE dbo.ASS_ENTRIES_POST_Lst

	@p_DATE varchar(10),

	@p_BRANCH_ID varchar(15) = '',

	@p_MAKER_ID VARCHAR(100) = NULL

AS

    DECLARE @p_BRANCH_CODE VARCHAR(20) = (SELECT CB.BRANCH_CODE FROM CM_BRANCH CB WHERE CB.BRANCH_ID = @p_BRANCH_ID)

	--LAY MA DON VI CUA HS NEU TIM THEO HS

	IF @p_BRANCH_ID = 'HS'

	BEGIN

		SELECT @p_BRANCH_ID = BRANCH_ID FROM CM_BRANCH WHERE BRANCH_TYPE = 'HS'

	END

	SELECT  A.*, TU2.TLFullName AS USER_NAME, TU.TLFullName AS AUTH_NAME

	FROM ASS_ENTRIES_POST_SYNC A

    LEFT JOIN TL_USER TU ON A.AUTH_ID = TU.TLNANME

    LEFT JOIN TL_USER TU2 ON A.USER_ID = TU2.TLNANME

	WHERE DATEDIFF(DAYOFYEAR,A.TRN_DT,CONVERT(datetime, @p_DATE,103)) = 0