Project

General

Profile

Download (290 Bytes)

PL_IMPORT_DT_ById.txt

Luc Tran Van, 12/08/2022 11:07 AM

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