ALTER PROCEDURE [dbo].[rpt_MW_IN_PNK_Excel_BanViet]
@IN_ID	varchar(15) = NULL
AS
SELECT Row_number() over(order by A.IN_ID) AS STT,A.*, B.GROUP_CODE, B.GROUP_NAME,C.MATERIAL_ACCTNO, C.MATERIAL_ACCTNO_NHNN, C.MATERIAL_CODE, A. MATERIAL_NAME,D.UNIT_ID, D.UNIT_CODE, D.UNIT_NAME
FROM MW_IN A 
LEFT JOIN MW_GROUP B ON A.GROUP_ID = B.GROUP_ID
LEFT JOIN MW_MATERIAL C ON A.MATERIAL_ID = C.MATERIAL_ID
LEFT JOIN CM_UNIT D ON C.UNIT_ID= D.UNIT_ID
WHERE  IN_MASTER_ID= @IN_ID OR @IN_ID IS NULL

SELECT TOP 1 N'TP. Hồ Chí Minh, ngày ' + RIGHT('0' + CAST(DATEPART(DD, A.CREATE_DT) AS VARCHAR(2)), 2)
+ N' tháng ' + RIGHT('0' + CAST(DATEPART(MM, A.CREATE_DT) AS VARCHAR(2)), 2)
+ N' năm ' + RIGHT(YEAR(A.CREATE_DT), 4) AS CREATE_DT
FROM MW_IN A 
WHERE  IN_MASTER_ID= @IN_ID OR @IN_ID IS NULL