script3.txt
| 1 |
|
|---|---|
| 2 |
SELECT TU.TLNAME AS TLNANME,US.TLFullName,TU.ROLE_NEW RoleName,Temp.DVDM_ID,TU.DEP_ID SECUR_CODE,TU.BRANCH_ID TLSUBBRID |
| 3 |
FROM dbo.TL_SYS_ROLE_MAPPING TU |
| 4 |
LEFT JOIN dbo.TL_USER US ON US.TLNANME=TU.TLNAME |
| 5 |
LEFT JOIN( |
| 6 |
SELECT PC.DVDM_ID,PD.DEP_ID,PD.BRANCH_ID FROM dbo.PL_COSTCENTER PC |
| 7 |
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 |
| 8 |
WHERE CAST(TU.EXP_DATE AS DATE) >= CAST(GETDATE() AS DATE) |
| 9 |
AND TU.TLNAME IN ('sangnm1','phuongtt4')
|
| 10 |
|
| 11 |
SELECT TU.TLNAME AS TLNANME,US.TLFullName,TU.ROLE_NEW RoleName,Temp.DVDM_ID,TU.DEP_ID SECUR_CODE,TU.BRANCH_ID TLSUBBRID |
| 12 |
FROM dbo.TL_SYS_ROLE_MAPPING TU |
| 13 |
LEFT JOIN dbo.TL_USER US ON US.TLNANME=TU.TLNAME |
| 14 |
LEFT JOIN( |
| 15 |
SELECT PC.DVDM_ID,PD.DEP_ID,PD.BRANCH_ID FROM dbo.PL_COSTCENTER PC |
| 16 |
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 |
| 17 |
WHERE CAST(TU.EXP_DATE AS DATE) >= CAST(GETDATE() AS DATE) |
| 18 |
AND Temp.DVDM_ID = 'DM0000000000072' |