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

ALTER PROC [dbo].[TR_REQ_PAY_METHOD_Search]

@p_ACC_NO varchar(15),

@p_ACC_NAME varchar(15),

@p_ISSUED_BY varchar(250),

@p_ISSUED_DT VARCHAR(20)

AS

BEGIN

	SELECT MAX(A.ACC_NO) AS ACC_NO, MAX(A.ACC_NAME) AS ACC_NAME, MAX(A.ISSUED_BY) AS ISSUED_BY  , MAX(A.ISSUED_DT) AS ISSUED_DT

	FROM TR_REQ_PAY_METHOD A

	WHERE (A.ACC_NO <> NULL OR A.ACC_NO <> '') AND (A.ACC_NAME <> NULL OR A.ACC_NAME <> '')

	AND (A.ACC_NO LIKE '%' + @p_ACC_NO + '%' OR  @p_ACC_NO IS NULL OR @p_ACC_NO = '')

	AND (A.ACC_NAME LIKE '%' + @p_ACC_NAME + '%' OR  @p_ACC_NAME IS NULL OR @p_ACC_NAME = '')

	AND (A.ISSUED_BY LIKE '%' + @p_ISSUED_BY + '%' OR  @p_ISSUED_BY IS NULL OR @p_ISSUED_BY = '')

	AND (A.ISSUED_DT LIKE '%' + @p_ISSUED_DT + '%' OR  @p_ISSUED_DT IS NULL OR @p_ISSUED_DT = '')

	GROUP BY A.ACC_NO, A.CHECK_IN

END