EXEC dbo.sp_generate_inserts @table_name = 'CM_DMMS', -- varchar(776) @from = 'FROM CM_DMMS' -- varchar(800) EXEC dbo.sp_generate_inserts @table_name = 'TL_SYSROLE_LIMIT', -- varchar(776) @from = 'FROM TL_SYSROLE_LIMIT' -- varchar(800) Trạng thái: Select thành công Column1 INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000001',N'DV0001',N'DEP000000000014',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000002',N'BRN000000000387',N'DEP000000000068',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000003',N'BRN000000000388',N'DEP000000000081',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS000000000035',N'BRN000000000829',N'BRN000000000829',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000004',N'BRN000000000389',N'DEP000000000093',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000005',N'BRN000000000390',N'DEP000000000105',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000006',N'BRN000000000391',N'DEP000000000117',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000007',N'BRN000000000392',N'DEP000000000128',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000008',N'BRN000000000393',N'DEP000000000146',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000009',N'BRN000000000394',N'DEP000000000158',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000010',N'BRN000000000395',N'DEP000000000164',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000011',N'BRN000000000396',N'DEP000000000182',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000012',N'BRN000000000397',N'DEP000000000194',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000013',N'BRN000000000398',N'DEP000000000200',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000014',N'BRN000000000399',N'DEP000000000213',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000015',N'BRN000000000400',N'DEP000000000229',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000016',N'BRN000000000401',N'DEP000000000242',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000017',N'BRN000000000402',N'DEP000000000254',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000018',N'BRN000000000403',N'DEP000000000266',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000019',N'BRN000000000404',N'DEP000000000272',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000020',N'BRN000000000405',N'DEP000000000284',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000021',N'BRN000000000406',N'DEP000000000296',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000022',N'BRN000000000407',N'DEP000000000308',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000023',N'BRN000000000418',N'DEP000000000390',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000024',N'BRN000000000422',N'DEP000000000423',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000025',N'BRN000000000432',N'DEP000000000503',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000026',N'BRN000000000817',N'DEP000000000537',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000027',N'BRN000000000818',N'DEP000000000549',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000028',N'BRN000000000819',N'DEP000000000556',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000029',N'BRN000000000820',N'DEP000000000567',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000030',N'BRN000000000821',N'DEP000000000579',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000031',N'BRN000000001841',N'DEP000000000579',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000032',N'BRN000000001839',N'DEP000000000579',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000033',N'BRN000000001842',N'DEP000000000579',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000034',N'BRN000000001840',N'DEP000000000579',N'') INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000112',N'BRN000000000408',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000113',N'BRN000000000409',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000114',N'BRN000000000410',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000115',N'BRN000000000411',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000116',N'BRN000000000412',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000117',N'BRN000000000413',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000118',N'BRN000000000414',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000119',N'BRN000000000415',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000120',N'BRN000000000416',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000121',N'BRN000000000417',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000123',N'BRN000000000419',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000124',N'BRN000000000420',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000125',N'BRN000000000421',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000126',N'BRN000000000422',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000127',N'BRN000000000423',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000128',N'BRN000000000424',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000129',N'BRN000000000425',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000130',N'BRN000000000426',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000131',N'BRN000000000427',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000132',N'BRN000000000428',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000133',N'BRN000000000429',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000134',N'BRN000000000430',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000136',N'BRN000000000431',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000138',N'BRN000000000433',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000139',N'BRN000000000434',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000140',N'BRN000000000435',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000146',N'BRN000000000822',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000147',N'BRN000000000823',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000148',N'BRN000000000824',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000149',N'BRN000000000825',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000150',N'BRN000000000826',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000151',N'BRN000000000827',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000152',N'BRN000000000828',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000153',N'BRN000000000829',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000154',N'BRN000000000830',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000155',N'BRN000000000831',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000156',N'BRN000000000832',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000157',N'BRN000000000833',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000158',N'BRN000000000834',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000159',N'BRN000000000835',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000160',N'BRN000000000836',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000161',N'BRN000000000837',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000163',N'BRN000000001838',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000165',N'BRN000000251844',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000168',N'BRN000000251847',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000169',N'BRN000000251848',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000170',N'BRN000000251851',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000171',N'BRN000000251852',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000172',N'BRN000000251853',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000173',N'BRN000000251854',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000177',N'BRN000000001842',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000178',N'BRN000000001843',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000179',N'BRN000000251849',NULL,NULL) INSERT INTO [CM_DMMS] ([DMMS_ID],[BRANCH_ID],[DEP_ID],[DVDM_ID])VALUES(N'DMMS00000000180',N'BRN000000251850',NULL,NULL) Column1 INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000001',N'GDK',150000000,NULL,N'admin',N'U',N'luctv',N'Jun 4 2020 5:17PM',NULL,N'CN',N'TTCT',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000002',N'PGD',250000000,NULL,N'admin',N'U',NULL,NULL,NULL,N'HS',N'TTCT',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM0000025',N'PTGD',250000000,N'PTGD_CDT_1',N'admin',N'U',NULL,NULL,NULL,N'2',N'TTCT_CDT',1,N'DM0000000000015') INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000003',N'TGD',550000000,NULL,N'admin',N'U',NULL,NULL,NULL,NULL,N'TTCT',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000004',N'GDDV',70000000,NULL,N'admin',N'U',N'luctv',N'Jun 4 2020 5:21PM',NULL,NULL,N'TTCT',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000006',N'PGD',200000000,NULL,N'admin',N'U',NULL,NULL,NULL,N'HS',N'DCNS',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000007',N'TGD',550000000,NULL,N'admin',N'U',NULL,NULL,NULL,NULL,N'DCNS',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000008',N'GDDV',350000000,NULL,N'admin',N'U',NULL,NULL,NULL,NULL,N'DCNS',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000009',N'KT',50000000,NULL,N'admin',N'U',NULL,NULL,NULL,NULL,N'DCNS',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000012',N'GDK',200000000,N'GDK_DC',N'admin',N'U',NULL,NULL,NULL,N'1',N'DCNS',2,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000013',N'DVKD',70000000,NULL,N'admin',N'U',NULL,NULL,NULL,NULL,N'PYC',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000013',N'PTGD',200000000,N'PTGD_DC',N'admin',N'U',NULL,NULL,NULL,N'2',N'DCNS',2,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000014',N'TGD',NULL,N'TGD_DC',N'admin',N'U',NULL,NULL,NULL,N'3',N'DCNS',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000015',N'TGD',NULL,N'TGD',N'admin',N'U',NULL,NULL,NULL,N'4',N'TTCT_CDT',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000019',N'PTGD',350000000,N'PTGD_CDT_2',N'admin',N'U',NULL,NULL,NULL,N'3',N'TTCT_CDT',NULL,N'DM0000000000017') INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000020',N'GDK',NULL,N'',N'',N'',N'',N'Aug 15 2020 1:40PM',N'',N'',N'PDPYC',0,N'DM0000000000015') INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM000090',N'KSV',50000000,N'',N'admin',N'U',N'',N'Jul 13 2020 1:58PM',NULL,NULL,N'KT',NULL,N'DM0000000000006') INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LM1111',N'CDT',NULL,N'',N'',N'',N'',N'Aug 15 2020 9:59PM',N'',N'',N'CDT',0,N'DM0000000000015') INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LMID00000001',N'GDDV',20000000,N'',N'',N'',N'',N'Sep 7 2020 6:18PM',N'',N'',N'PYC_DVMC',NULL,N'') INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LMPYC001',N'',20000000,N'',N'',N'',N'',N'Nov 11 2020 9:39AM',N'',N'',N'PYCMS_DVKD',NULL,N'') INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'LMPYC002',N'',5000000,N'',N'',N'',N'',N'Nov 11 2020 9:39AM',N'',N'',N'PYCMS_DVCM',NULL,N'') INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TLRM00000000001',N'GDDV',40000000,NULL,N'luctv',N'U',NULL,N'Jan 1 1900 12:00AM',NULL,N'DV0001',N'DCNS',NULL,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TLRM00000000002',N'GDDV',40000000,NULL,N'vanpt2',N'U',NULL,N'Jan 1 1900 12:00AM',NULL,N'BRN000000001841',N'ADV_PAY',40000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TLRM00000000003',N'GDDV',40000000,NULL,N'baotq',N'U',NULL,N'Jan 1 1900 12:00AM',NULL,N'BRN000000001840',N'ADV_PAY',40000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TLRM00000000004',N'TPGD',40000000,NULL,N'baotq',N'U',NULL,N'Jan 1 1900 12:00AM',NULL,N'BRN000000000833',N'ADV_PAY',50000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000127',N'GDDV',80000000,N'CHI NHANH NAM SAI GON',N'admin',N'U',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000388',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000128',N'GDDV',80000000,N'CHI NHANH TP HO CHI MINH',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000389',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000129',N'GDDV',90000000,N'CHI NHANH HA NOI',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000390',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000130',N'GDDV',50000000,N'CHI NHANH DA NANG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000391',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000131',N'GDDV',70000000,N'CHI NHANH CAN THO',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000392',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000132',N'GDDV',70000000,N'CHI NHANH DAK LAK',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000393',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000133',N'GDDV',60000000,N'CHI NHANH VUNG TAU',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000394',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000134',N'GDDV',70000000,N'CHI NHANH BINH DUONG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000395',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000135',N'GDDV',60000000,N'CHI NHANH LONG AN',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000396',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000136',N'GDDV',70000000,N'CHI NHANH TAY NINH',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000397',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000137',N'GDDV',70000000,N'CHI NHANH TIEN GIANG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000398',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000138',N'GDDV',60000000,N'CHI NHANH AN GIANG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000399',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000139',N'GDDV',70000000,N'CHI NHANH DONG NAI',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000400',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000140',N'GDDV',50000000,N'CHI NHANH NHA TRANG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000401',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000141',N'GDDV',60000000,N'CHI NHANH BINH THUAN',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000402',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000142',N'GDDV',50000000,N'CHI NHANH KIEN GIANG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000403',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000143',N'GDDV',50000000,N'CHI NHANH QUANG NINH',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000404',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000144',N'GDDV',50000000,N'CHI NHANH HAI PHONG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000405',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000145',N'GDDV',50000000,N'CHI NHANH THANG LONG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000406',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000146',N'GDDV',50000000,N'CHI NHANH CA MAU',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000407',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000147',N'GDDV',40000000,N'PGD CHI LANG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000418',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000148',N'GDDV',40000000,N'PGD PHU MY HUNG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000422',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000149',N'GDDV',40000000,N'PGD HAI CHAU',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000432',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000150',N'GDDV',40000000,N'CHI NHANH SOC TRANG',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000817',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000151',N'GDDV',40000000,N'CHI NHANH GIA LAI',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000818',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000152',N'GDDV',40000000,N'CHI NHANH BAC NINH',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000819',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000153',N'GDDV',40000000,N'CHI NHANH NGHE AN',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000820',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000154',N'GDDV',40000000,N'TTKD',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'BRN000000000821',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000155',N'GDK',500000000,N'HAN MUC GIAM DOC KHOI',N'admin',N'U',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'DV0001',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000156',N'PTGD',1000000000,N'HAN MUC GIAM DOC KHOI',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'DV0001',N'ADV_PAY',100000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000157',N'TGD',2000000000,N'HAN MUC GIAM DOC KHOI',N'admin',N'A',N'tscd_hoiso',N'Feb 25 2020 11:54AM',N'1',N'DV0001',N'ADV_PAY',500000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000178',N'GDDV',40000000,N'CHI NHANH LAM DONG',N'admin',N'A',N'tscd_hoiso',N'Mar 10 2020 11:05AM',N'1',N'BRN000000000843',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000179',N'GDDV',40000000,N'CHI NHANH DONG THAP',N'admin',N'A',N'tscd_hoiso',N'Mar 10 2020 11:05AM',N'1',N'BRN000000000844',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000183',N'GDDV',40000000,N'CHI NHANH HA TAY',N'admin',N'A',N'tscd_hoiso',N'Mar 10 2020 11:05AM',N'1',N'BRN000000000849',N'ADV_PAY',50000000,NULL) INSERT INTO [TL_SYSROLE_LIMIT] ([LIMIT_ID],[ROLE_ID],[LIMIT_VALUE],[NOTES],[MAKER_ID],[AUTH_STATUS],[CHECKER_ID],[DATE_APPROVE],[ISAPPROVE],[BRANCH_ID],[LIMIT_TYPE],[LIMIT_PERCENT],[DVDM_ID])VALUES(N'TSRL00000000184',N'HDQT',20000000000,N'HAN MUC HDQT',N'admin',N'A',N'tscd_hoiso',N'Aug 16 2020 10:31PM',N'1',N'DV0001',N'ADV_PAY',10000000000,NULL) Result ErrorDesc SUCCESSFULL