UPDATE dbo.SYS_GROUP_LIMIT SET IS_HO=0
UPDATE dbo.SYS_GROUP_LIMIT SET IS_HO=1 WHERE GROUP_CODE='I.1.1.A'
UPDATE dbo.SYS_GROUP_LIMIT SET IS_HO=1 WHERE GROUP_CODE='I.3.1'
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000523', N'SGL000000000099', N'PTGD', CAST(300000000 AS Decimal(18, 0)), N'', N'DM0000000000015')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000524', N'SGL000000000099', N'GDK', CAST(100000000 AS Decimal(18, 0)), N'', N'DM0000000000015')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000525', N'SGL000000000099', N'GDDV', CAST(-1 AS Decimal(18, 0)), N'DV0001', N'')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000526', N'SGL000000000100', N'TGD', CAST(1000000000 AS Decimal(18, 0)), N'', N'')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000527', N'SGL000000000100', N'PTGD', CAST(-1 AS Decimal(18, 0)), N'', N'DM0000000000015')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000528', N'SGL000000000100', N'GDK', CAST(-1 AS Decimal(18, 0)), N'', N'DM0000000000015')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000529', N'SGL000000000100', N'GDDV', CAST(-1 AS Decimal(18, 0)), N'DV0001', N'')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000530', N'SGL000000000101', N'TGD', CAST(2000000000 AS Decimal(18, 0)), N'', N'')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000531', N'SGL000000000101', N'PTGD', CAST(300000000 AS Decimal(18, 0)), N'', N'DM0000000000015')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000532', N'SGL000000000101', N'GDK', CAST(100000000 AS Decimal(18, 0)), N'', N'DM0000000000015')
INSERT [dbo].[SYS_GROUP_LIMIT_DT] ([GROUD_LM_DTID], [GROUP_LM_ID], [ROLE_ID], [VALUE_LIMIT], [BRANCH_ID], [DVDM_ID]) VALUES (N'SGLDT0000000533', N'SGL000000000101', N'GDDV', CAST(-1 AS Decimal(18, 0)), N'DV0001', N'')