DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

SELECT RoleName,TLSUBBRID,SECUR_CODE FROM dbo.TL_USER TU
WHERE TLNANME='longdk'
UNION ALL
SELECT TM.ROLE_NEW RoleName,TLSUBBRID,SECUR_CODE FROM dbo.TL_USER TU
LEFT JOIN dbo.TL_SYS_ROLE_MAPPING TM ON TM.ROLE_OLD=TU.RoleName AND
WHERE TLNANME='longdk' AND TM.ROLE_NEW IS NOT NULL
UNION ALL
SELECT TM1.ROLE_NEW RoleName,TM1.BRANCH_ID TLSUBBRID,TM1.DEP_ID SECUR_CODE FROM dbo.TL_SYS_ROLE_MAPPING TM1
WHERE TM1.TLNAME='longdk' AND CAST >= CAST AS DATE)
UNION ALL
SELECT TM.ROLE_NEW RoleName,TM1.BRANCH_ID TLSUBBRID,TM1.DEP_ID SECUR_CODE FROM dbo.TL_SYS_ROLE_MAPPING TM1
LEFT JOIN dbo.TL_SYS_ROLE_MAPPING TM ON TM.ROLE_OLD=TM1.ROLE_NEW AND
WHERE TM1.TLNAME='longdk' AND CAST >= CAST AS DATE)

SELECT * FROM dbo.ASS_ENTRIES_POST WHERE MAKER_ID ='thoatk1'

UPDATE TR_REQUEST_DOC_DT SET
DESCRIPTION = N''
WHERE REQDT_ID =

SELECT dbo.FN_CHECK_LIMIT_PL_REQ('PLRD00000205929', 'GDK')

PLRD00000205852