ALTER PROCEDURE dbo.PL_IMPORT_DT_ById
	@p_IMPORT_ID	varchar(15)		
AS 
SELECT Row_number() over(order by DT.IMP_DT_ID) AS STT,DT.*, pi.IMP_YEAR, YEAR(pi.EDIT_DT) AS EDIT_DT
FROM dbo.PL_IMPORT_DT DT  
LEFT JOIN PL_IMPORT pi ON DT.IMPORT_ID = pi.IMPORT_ID
WHERE DT.IMPORT_ID=@p_IMPORT_ID