DELETE FROM TL_SYSROLE_LIMIT WHERE LIMIT_TYPE='DCNS' 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',150000000,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'PTGD',150000000,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'LMI00014',N'GDDV',20000000,N'',N'',N'',N'',N'Nov 30 2020 10:33AM',N'',N'',N'DCNS',30,N'')