SELECT TU.TLNAME AS TLNANME,US.TLFullName,TU.ROLE_NEW RoleName,Temp.DVDM_ID,TU.DEP_ID SECUR_CODE,TU.BRANCH_ID TLSUBBRID
		FROM dbo.TL_SYS_ROLE_MAPPING TU
		LEFT JOIN dbo.TL_USER US ON US.TLNANME=TU.TLNAME
		LEFT JOIN(
		SELECT PC.DVDM_ID,PD.DEP_ID,PD.BRANCH_ID FROM dbo.PL_COSTCENTER PC 
		LEFT JOIN dbo.PL_COSTCENTER_DT PD ON PC.COST_ID=PD.COST_ID) Temp ON Temp.DEP_ID=TU.DEP_ID AND Temp.BRANCH_ID=TU.BRANCH_ID
		WHERE  CAST(TU.EXP_DATE AS DATE) >= CAST(GETDATE() AS DATE)
    AND TU.TLNAME IN ('sangnm1','phuongtt4')

SELECT TU.TLNAME AS TLNANME,US.TLFullName,TU.ROLE_NEW RoleName,Temp.DVDM_ID,TU.DEP_ID SECUR_CODE,TU.BRANCH_ID TLSUBBRID
		FROM dbo.TL_SYS_ROLE_MAPPING TU
		LEFT JOIN dbo.TL_USER US ON US.TLNANME=TU.TLNAME
		LEFT JOIN(
		SELECT PC.DVDM_ID,PD.DEP_ID,PD.BRANCH_ID FROM dbo.PL_COSTCENTER PC 
		LEFT JOIN dbo.PL_COSTCENTER_DT PD ON PC.COST_ID=PD.COST_ID) Temp ON Temp.DEP_ID=TU.DEP_ID AND Temp.BRANCH_ID=TU.BRANCH_ID
		WHERE  CAST(TU.EXP_DATE AS DATE) >= CAST(GETDATE() AS DATE)
    AND Temp.DVDM_ID = 'DM0000000000072'