sql server同一字段多条记录的合并（ sql server 2008以上）

先执行以下sql语句

USE [wlwzbgl]GO/****** Object:  Table [dbo].[t_rw_gzrw]    Script Date: 2014/9/18 17:20:46 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_rw_gzrw]([sid] [varchar](50) NOT NULL,[rwbt] [varchar](100) NULL,[sqrid] [varchar](30) NULL,[sqbmid] [varchar](50) NULL,[sqsj] [datetime] NULL,[gznr] [varchar](100) NULL,[kssj] [datetime] NULL,[jssj] [datetime] NULL,[zxdwid] [varchar](5000) NULL,[rwlx] [varchar](30) NULL,[pl] [varchar](10) NULL,[sfqy] [varchar](4) NULL, CONSTRAINT [PK_T_RW_GZRW] PRIMARY KEY CLUSTERED ([sid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[t_rw_gzrw_zblb]    Script Date: 2014/9/18 17:20:46 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_rw_gzrw_zblb]([sid] [varchar](50) NOT NULL,[gzrwxqid] [varchar](30) NULL,[zbid] [varchar](50) NULL,[zbbm] [varchar](30) NULL,[zbmc] [varchar](30) NULL,[zbzt] [varchar](30) NULL,[smsj] [datetime] NULL, CONSTRAINT [PK_T_RW_GZRW_ZBLB] PRIMARY KEY CLUSTERED ([sid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[t_rw_gzrw_zzjg]    Script Date: 2014/9/18 17:20:46 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_rw_gzrw_zzjg]([sid] [varchar](30) NOT NULL,[ssrwid] [varchar](100) NULL,[ssjgid] [varchar](50) NULL, CONSTRAINT [PK_T_RW_GZRW_ZZJG] PRIMARY KEY CLUSTERED ([sid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[t_rw_gzrwxq]    Script Date: 2014/9/18 17:20:46 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_rw_gzrwxq]([sid] [varchar](30) NOT NULL,[rwid] [varchar](50) NULL,[zxdwid] [varchar](50) NULL,[kssj] [datetime] NULL,[jssj] [datetime] NULL,[smsl] [varchar](8) NULL,[wsmsl] [varchar](8) NULL,[czr] [varchar](30) NULL,[lxdh] [varchar](30) NULL,[wsmyy] [varchar](100) NULL, CONSTRAINT [PK_T_RW_GZRWXQ] PRIMARY KEY CLUSTERED ([sid] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  Table [dbo].[t_sys_zzjg]    Script Date: 2014/9/18 17:20:46 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOSET ANSI_PADDING ONGOCREATE TABLE [dbo].[t_sys_zzjg]([zzjg_id] [varchar](50) NULL,[zzmc] [varchar](200) NULL,[sjzzjg_id] [varchar](50) NULL,[xh] [int] NULL,[jgtree] [varchar](100) NULL) ON [PRIMARY]GOSET ANSI_PADDING OFFGO/****** Object:  View [dbo].[v_gzrw_zzjg]    Script Date: 2014/9/18 17:20:46 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOcreate view [dbo].[v_gzrw_zzjg]asselect a1.ssrwid,a1.ssjgid,a2.zzmc from t_rw_gzrw_zzjg a1,t_sys_zzjg a2 where a1.ssjgid = a2.zzjg_idGOINSERT [dbo].[t_rw_gzrw] ([sid], [rwbt], [sqrid], [sqbmid], [sqsj], [gznr], [kssj], [jssj], [zxdwid], [rwlx], [pl], [sfqy]) VALUES (N'140918163731648562', N'CJJH_201409181636', N'003', N'b426d03a207246a18c89bb943c4d3741', CAST(N'2014-09-18 16:36:00.000' AS DateTime), N'十月一快乐……', CAST(N'2014-09-19 16:36:00.000' AS DateTime), CAST(N'2014-09-20 16:36:00.000' AS DateTime), NULL, N'临时', NULL, N'是')INSERT [dbo].[t_rw_gzrw] ([sid], [rwbt], [sqrid], [sqbmid], [sqsj], [gznr], [kssj], [jssj], [zxdwid], [rwlx], [pl], [sfqy]) VALUES (N'194EADBD6CBC42C89C5A210F4AAB908A', N'1任务', N'140716151912536133', N'384df1110cd84797a6ebd3ef3d5d2e30', CAST(N'2004-12-11 00:00:00.000' AS DateTime), N'内容', CAST(N'2014-10-10 15:06:32.660' AS DateTime), CAST(N'2015-10-10 15:06:32.660' AS DateTime), N'b426d03a207246a18c89bb943c4d3741;dfa2b652d1434b319ec846ab0db0b15f', N'月', NULL, N'是')INSERT [dbo].[t_rw_gzrw] ([sid], [rwbt], [sqrid], [sqbmid], [sqsj], [gznr], [kssj], [jssj], [zxdwid], [rwlx], [pl], [sfqy]) VALUES (N'1ADF3FD7F7E749B38A8A250730D09B5B', N'2任务', N'140716151912536133', N'dfa2b652d1434b319ec846ab0db0b15f', CAST(N'2004-09-11 15:06:32.000' AS DateTime), N'尽快完成', CAST(N'2014-11-10 15:06:32.000' AS DateTime), CAST(N'2014-12-10 15:06:32.000' AS DateTime), N'dfa2b652d1434b319ec846ab0db0b15f', N'临时', NULL, NULL)INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'001', N'2', N'402880db3550203d0135803930770160', N'210101020D1130112000', N'泡沫消防车（PM）', N'2', NULL)INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'002', N'2', N'8a988acf35e818cf0135fc863c0e3f71', N'210101018Q1130112003', N'水罐消防车（SG）', N'2', NULL)INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'003', N'2', N'402880db3550203d0135803930770160', N'210101020D1130112000', N'泡沫消防车（PM）', N'2', NULL)INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'004', N'2', N'8a988acf35e818cf0135fc863c0e3f71', N'210101018Q1130112003', N'水罐消防车（SG）', N'2', NULL)INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'4307A7F9D2114B4284C91ECBB30DAEA9', N'1', N'0002', N'0002', N'www', N'0', CAST(N'2014-09-14 15:35:15.000' AS DateTime))INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'6AE5015677734FFFA76258BBE7F4FBBF', N'1', N'0002', N'0002', N'www', N'0', CAST(N'2014-09-14 15:35:15.000' AS DateTime))INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'6FE6160DA1CB4C3AA8542BF9E956ED8F', N'1', N'0002', N'0002', N'www', N'0', CAST(N'2014-09-14 15:35:15.000' AS DateTime))INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'90DB6A906B6A454F911174B23DCA11DB', N'1', N'0001', N'0001', N'qqq', N'0', CAST(N'2014-09-15 15:20:30.000' AS DateTime))INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'D9CB55261357479AB9105F2C3138EED0', N'1', N'0001', N'0001', N'qqq', N'0', CAST(N'2014-09-15 15:20:30.000' AS DateTime))INSERT [dbo].[t_rw_gzrw_zblb] ([sid], [gzrwxqid], [zbid], [zbbm], [zbmc], [zbzt], [smsj]) VALUES (N'F08FA9D88C0248529DB2EB32328611E1', N'1', N'0001', N'0001', N'qqq', N'0', CAST(N'2014-09-15 15:20:30.000' AS DateTime))INSERT [dbo].[t_rw_gzrw_zzjg] ([sid], [ssrwid], [ssjgid]) VALUES (N'1', N'194EADBD6CBC42C89C5A210F4AAB908A', N'b426d03a207246a18c89bb943c4d3741')INSERT [dbo].[t_rw_gzrw_zzjg] ([sid], [ssrwid], [ssjgid]) VALUES (N'140918094219003109', N'1ADF3FD7F7E749B38A8A250730D09B5B', N'dfa2b652d1434b319ec846ab0db0b15f')INSERT [dbo].[t_rw_gzrw_zzjg] ([sid], [ssrwid], [ssjgid]) VALUES (N'140918163731715423', N'140918163731648562', N'76d6917e2b0c44c59aef54c7c4010a9d')INSERT [dbo].[t_rw_gzrw_zzjg] ([sid], [ssrwid], [ssjgid]) VALUES (N'2', N'194EADBD6CBC42C89C5A210F4AAB908A', N'dfa2b652d1434b319ec846ab0db0b15f')INSERT [dbo].[t_rw_gzrwxq] ([sid], [rwid], [zxdwid], [kssj], [jssj], [smsl], [wsmsl], [czr], [lxdh], [wsmyy]) VALUES (N'1', N'194EADBD6CBC42C89C5A210F4AAB908A', N'b426d03a207246a18c89bb943c4d3741', CAST(N'2004-12-11 00:00:00.000' AS DateTime), CAST(N'2004-12-14 00:00:00.000' AS DateTime), N'98', N'2', N'张三三', N'15033399888', N'你猜')INSERT [dbo].[t_rw_gzrwxq] ([sid], [rwid], [zxdwid], [kssj], [jssj], [smsl], [wsmsl], [czr], [lxdh], [wsmyy]) VALUES (N'2', N'194EADBD6CBC42C89C5A210F4AAB908A', N'dfa2b652d1434b319ec846ab0db0b15f', CAST(N'2004-12-13 00:00:00.000' AS DateTime), CAST(N'2004-12-15 00:00:00.000' AS DateTime), N'95', N'5', N'刘四', N'13033355000', N'你再猜')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'470e7b44e2c4407aa1ae5b75ff3267d6', N'冀州市消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'252e947a79e44df6a25e727ff4b96619', N'井陉县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'25521ac7b8484912ae02033c014610c1', N'保定市公安消防支队新市区大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1c758626736c44158b58cbd62dea8c02', N'灵寿县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1ca921b38cdd4c559416ee1225c3a7ec', N'七中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009308')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6f9320c120ff4d5ab7813327f0e7e106', N'故城县消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'59a5df16af1d47719783bcfe38c3d55f', N'赵县中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001356')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5a1973d744db4733baf3a6eb08f4ab54', N'政治处', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5ac0648dc3aa40869c6fed9cc7bdf77e', N'藁城县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001235')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5d937c1e9714435e95d35871a1b36074', N'行唐中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001364')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6c846644ee634beeb76b39ca5127f7df', N'崇礼县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005230')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6d280569d7d94fd1b4f3815a4e9104e9', N'青龙县公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6e5456f548394a54901bb50b0dcc9312', N'营房处', N'1a8d53170139421fbb20eb22d3e8f674', NULL, N'01000000130000001300003013000034')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6f81e725ab074560ba3570bee4bb2598', N'固安县公安消防大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'907ce3a01f2b4aacb5b4e9350b6cd815', N'北戴河疗养所', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013112042')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'902df7b4cf5a45ff8287c31dc9d44f55', N'矿区中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001363')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'91a9732d65e546bcabc66aa76c2c4464', N'防火监督处', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a2aab78595724bc1813bd8c0c5a3f4e8', N'任丘市公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011231')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a2309cd4a16247deb42b0af0995af9e0', N'武安市公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a37e89078d334d53bf306e0d0dfc1858', N'干部处', N'283e8fb178864b77baeaf537f4ea1ffa', NULL, N'01000000130000001300002013000022')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a3a4137a65b942a9ac06d8931d7bf36c', N'塞北消防科', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005237')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a3ef18cabee24308a2b6409e39d643c8', N'怀安县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005235')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a51f38fbf3ed477db27bfe3c0a9996b4', N'政治处', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a53d39bababa4e86bbe51cdae0bd5386', N'八中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009302')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a57a8c9fc05d428cadecce8288c96b20', N'遵化市公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'fce10f1bef0d45c987397d7dd32448e0', N'建审处', N'2883517c32f547b79eecb8c42363ce91', NULL, N'01000000130000001300004013000043')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c4de641495a043db9374ee4c9e354f19', N'保定市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013003000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c5e39de13e7449a29b8490651ffb6640', N'阜平县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c6f299712b8b411fa1dd502dbe522338', N'尚义县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005234')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c765ebbf550c42b88f1d472952bf5a18', N'唐山市公安消防支队曹妃甸工业区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002233')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c784625ab7dc475989d374cf6594e659', N'沧州市公安消防支队运河区大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd243197c6709496ca11abbee82b5cf52', N'马头公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008205')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd25f2cb326cd47cbb43b2dae1b11e296', N'赤城县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd3198a15e0c541558891cd012f9c9246', N'张北县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd4f53503507f4d3e94efd13ff3c5268e', N'赞皇中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001366')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd473477938f442e4ba52f3305ca56470', N'晋州市公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001233')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'fa547bc218ee4717936a38b081f89026', N'防火监督处', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'fb667e10d16d4b629919447c961350c2', N'康保县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005231')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'fca119026eac44569d49cc816ec08231', N'栾城县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'fcea9d03758d4892a644fbcde4608834', N'沽源县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005232')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'2eee25bd055a482ab3ca53754d0ee9e8', N'香河县公安消防大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'300fa42b45d94a6d92c79fbaf85c4bd0', N'司令部', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3134bc9c32404784819603e566d3bfef', N'邯郸县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'32399b5c58694e83bb7f8e2b3351b015', N'政治处', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'880ca666f5a048b992e22e373d609f93', N'技术处', N'2883517c32f547b79eecb8c42363ce91', NULL, N'01000000130000001300004013000047')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'34269ad817c3412b80c276e7efd5efa6', N'曲周县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008235')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'350ca17b93b5464c995d07ecf59c443f', N'汽训队', N'62358ae608e44b9483d58e81f1fb3263', NULL, N'01000000130000001301200013012003')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'92a7ec8b71a949faa1a4c44cad694f70', N'冀中公安局消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013112004')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'76d6917e2b0c44c59aef54c7c4010a9d', N'直属中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001016')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'760c552ac42d42f29c847ec448149bb5', N'新华区公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'774b804722314c20bd4a33ef01f3ba6f', N'防火监督处', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'86ec933d1ea94cb0b7089f973cd93097', N'威县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010233')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'76839160f5d44dc081e44fde2ed40ab4', N'玉田县公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'76dd27d257f34cfaacfbb9f803aeb401', N'深州市消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'77426fcd40734dbab6f36fd1628bfa2d', N'南宫市公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010236')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'84f4dd60ade74097bb0ee2d3170510bc', N'柏乡县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8523facd673a45b0a27c2293c643a7fa', N'阜城县消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'85a4b1f4f8554ec381289ab9ca1dce11', N'开发区公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008204')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8603a1cc863947ba92f7135699196ab3', N'巨鹿县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010229')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'861b071c6c0f446b9ddece727f415834', N'鹰手营子矿区公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'889663bf14ab49059420f5c66d585002', N'怀来县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005229')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'88da5485b15e46989f89f0bab5a38651', N'赵县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001230')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8b804170f81b44fc8491aa7b5d886cff', N'高邑中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001353')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'9434698352074eeb8078193054e7f635', N'后勤处', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8bb4467ec35a4533b0093d77e1a495ff', N'新乐市公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8cda36be9f8647709d836d9428375dcb', N'市开发区公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009204')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8e8beba11f2f4774a99a6d935aeb1509', N'法规处', N'2883517c32f547b79eecb8c42363ce91', NULL, N'01000000130000001300004013000042')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8eac247b3c434bd3b1a9b201261231c7', N'特勤中队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005303')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8f933a7929dc4134b7ec3c8d40bf0054', N'沙河市公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010237')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c48c8f865efc4b7d8e2394562733b33b', N'廊坊市公安消防支队经济技术开发区大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'dfa2b652d1434b319ec846ab0db0b15f', N'司令部', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'dfa3248966be43c3b7b143d033543005', N'后勤处', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'dfec6da16b794db188a22960202de5a2', N'平泉县公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e212750744fe48568818b1edf67796b2', N'司令部', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e28ffbf90a3b4d6e9d858378962acfe7', N'保定市公安消防支队南市区大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e2938be41a354da28c55707721b62cac', N'海兴县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011232')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ee3a89f1113941d99c3b6d97f51f4c47', N'司令部', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ef193b9fb7704c52b1f51d084b88ab2a', N'防火监督处', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e2b91fbd1a03419a93737f7090d54e3c', N'博野县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ee17b259b37c4645b88e8dc9e6a2ac10', N'馆陶县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008233')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f0e65e2ef2ea4365852d48343647e282', N'武邑县消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f100219e7841484183d02e69498f28c3', N'唐山市公安消防支队开平区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002206')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f191cac88c494ce390e0ccc1cbb442e0', N'唐山市公安消防支队培训基地', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002018')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f253aba4154f48d4b1836559ee9d6cee', N'沧州市公安消防支队新华区大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f340cae30f8d43f493805af366a17034', N'万全县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005233')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f4dc1b46b2a0491b83cecb84cfdd84bb', N'泊头市公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c8c8c33c196f4b0f9e678a0b497b1e15', N'政治处', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ca2702687c004926bca73884dbc48bbe', N'六中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009306')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f77de6e571814dcaad8ffde84b25e0ec', N'承德县公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f812f475b59a4433b3fcc4141563d58d', N'文安县公安消防大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f8611ffd14b4481e8a4b2b03184ff0ab', N'平山中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001355')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f8a8eaa249124d1c93123f4a0df82f55', N'乐亭县公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002231')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f8b15a3c501346389545d0001417993a', N'南和县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f943a00f400c4a548025f0e5f72bf712', N'廊坊市公安消防支队广阳区大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'bac45c030b6e463cb665d2236ed7444a', N'防火监督处', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'bb52938ad0444697904f00c768b025b4', N'后勤处', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c798cd891cfe4b13956250f62dcbb35b', N'雄县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003234')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c848e10e00d24936b2b8c9529a454552', N'鹿泉中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001362')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c7b804d6fa394865936300c7e8fdfeb1', N'办公室', N'62358ae608e44b9483d58e81f1fb3263', NULL, N'01000000130000001301200013012001')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c87feb8b51924c0fa40097d71638bcd0', N'邯郸市公安消防支队邯山区大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008201')GOINSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c88eea3923a547cfa723c85cd483e21d', N'围场县公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ca724865815b4d0fa843c57f56bf2db9', N'曲阳县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'cae551a2c570430e81f429f1b30fb9ac', N'桃城区消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'cb13ac6d11a448a8aacf28bdfdb989c1', N'涿州市公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003232')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'cb5da51196724fca97f23a8f2db83da2', N'政治处', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'cbdb0081ab854916bc40fc907c87a841', N'招待所', N'1a8d53170139421fbb20eb22d3e8f674', NULL, N'01000000130000001300003013000039')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'cbf119633c794c8fa977614d04c5ac90', N'元氏中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001367')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'48022d40b4e64c13b28b6a96e6f95c57', N'井陉中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001358')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'4812c9dbf92c4aa0a6cefe1ac5fdc875', N'蔚县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'4902fb850f334bf3a00a248eef6bae71', N'宁晋县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'494590dd0dfb4eb2b6e9f9b4e90db424', N'中捷消防科', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011237')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'49be0c67d4874c4bacb4b762459b5120', N'永年县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'4cbf60d35d3c47a2af3de7b9ea6a93b1', N'沧州市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013011000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5e55d4ea927b49aa8f1f786f0367fad6', N'唐山市公安消防支队海港经济开发区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002232')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5f90e521190e41188fd748bc8e7a85b3', N'行唐县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001237')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5fc7481f3e2744afa6562f5581a568ab', N'涉县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'607bf0e2a54147c6835967ffff0bc925', N'唐山市公安消防支队路北区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002205')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6125077effa94e2abb9a873fbdf2f20c', N'司令部', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6185d3771c8d4a80b5db844f821e0d3e', N'司令部', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'62289e876f82454ba05fd9459012fa6b', N'易县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003241')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'27a47e6327b546958f6812edc52efde2', N'沧县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'27b128c647e948aa9029ebdb714aa5f4', N'保定市公安消防支队朝阳大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003204')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'27c7edcb52004283a88718053995baae', N'内邱县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'283e8fb178864b77baeaf537f4ea1ffa', N'政治部', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013000020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'2883517c32f547b79eecb8c42363ce91', N'防火监督部', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013000040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'2aff638261f24cb9b78e9f77745131e9', N'后勤处', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'2c5db93cf5ce46a69e414fb4067ac12f', N'鹿泉市公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'2ca511e6bd774b9191597284253f5f6e', N'后勤处', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'2e140f3a54784dfb8e0cab59e8c2c7f6', N'信息通信处', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013000014')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'7d0a1b3e1eb1462fb08130ff41238d79', N'政治处', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'788661af0b9141aa943c0858e74fc76d', N'赞皇县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001231')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'7924b0cb53f14fdcaf1d0c439818383f', N'保定市公安消防支队白沟新城大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003205')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'79374e667d2e47fd83845087df37dea4', N'宣化区公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'79a2fddfb1a34567b2f375f42d6ff101', N'保定市公安消防支队培训基地', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003102')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'7d1ee2366c754089a58b6713e5727d81', N'鸡泽县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008236')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'7ce2ba0047904ef7a4dc114e89ab7419', N'宽城县公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'7ed1387e57a94f83b15d656a9bc7b95f', N'邢台市公安消防支队桥西区大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'7fa6004b8a0841ea83de64a2cea283ea', N'霸州市公安消防大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'36768ae261594766a4c57193b11a1c38', N'南堡经济技术开发区公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'37e3f3ccdbc244fb9dbe823cfaa5ec20', N'政治处', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'37fb5b8154a24235a024b5e44a0eaf9d', N'桥西区公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'384df1110cd84797a6ebd3ef3d5d2e30', N'河北省公安消防总队', NULL, NULL, N'0100000013000000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'39a4467db759470c93ebe3a4527138eb', N'特勤大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009101')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'70e69095cb5143dba853fa1d9a9c415e', N'裕华区公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001204')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'719e9da28385411d84a4d6f76627d38d', N'防火监督处', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'71d4ecfdc9784e749509c3e06d4339ed', N'唐山市公安消防支队古冶区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'71eaa4b2cf35435ea7c2b174f38fee61', N'定州市公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003233')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'72157ba3329e471e8afcfe38f77d8927', N'信息宣传中心', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013000045')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'734bdaf8d2344feaa57bc564f5f2f97f', N'黄骅市公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'74137bbf5f1b4267b84261b468cc9811', N'徐水县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'759e04352b4b4a8e8d64188097b0f240', N'大名县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008230')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'75baa7ed44e346ecb5114dee4f672df9', N'装备运输处', N'1a8d53170139421fbb20eb22d3e8f674', NULL, N'01000000130000001300003013000032')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a8c2f21bc17048a0895e73dabab0393f', N'藁城中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001313')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a6cc8f237647481096fbeb281db2ae78', N'司令部', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'aa340a1b750c48848766e529d1055a54', N'衡水市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013007000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'aa8d9dd3e3d649699540c2a2b5ceeaf0', N'仓库', N'1a8d53170139421fbb20eb22d3e8f674', NULL, N'01000000130000001300003013000035')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a99368c137794b608367c749ed013011', N'双滦区公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'aaeeb078a730447fb5b25b864364c5a9', N'专职队伍指导处', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013000019')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ab20cb7bbaf246cfab135854d7201334', N'防火监督处', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ab571073e7a04a88acc79249bacc9a4e', N'政治处', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0aa3a063352b4f92925d8a6c0654e9eb', N'七中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001307')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0986808343b04c99872961ea886eb309', N'高新技术产业开发区公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0bb539261b49434b96f661d3015f91a1', N'防火监督处', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0bb64cff77d1409b8cf16d40f13dca12', N'高邑县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001234')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0d45b7d73497406ea0f7d322c0d70241', N'山海关区公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0d5f65ca6a92406e957e07cef98fe1f0', N'特勤中队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007301')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3ddf6e03d87c4c2ab8bae668e962605c', N'丰宁县公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3f3fe115d32e4fcaae87b89fd96319a5', N'成安县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd99d00d76f264310aa29ab95b06c6225', N'枣强县消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'dc744b0d235f4f6d8efa6c96212c2846', N'邢台市公安消防支队桥东区大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'40e1388eee7d40f2b867ce604960b986', N'特勤三中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001316')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'41c3287ac4904fdab74785d222d74194', N'特勤一中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001314')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'41df9228d0df4bc28d30fc22ce615926', N'卢龙县公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'420a423813e44917bfa72a70420b64f4', N'安新县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'42465f281a614a1081ee23640608057d', N'海港区公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'447d198c2e2f448f9c0907b1d329a31c', N'深泽中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001354')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd83dcc5a5108461ab01066c5a90f77e2', N'特勤二中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009309')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd87ea8481f3d429ba3913cf6d2cab550', N'南大港消防科', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011233')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd89838b643f54a5b8c84183b01403f2f', N'政治处', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd89f141fe93a45d5898e0f29c52a26f7', N'河间市公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e3f050157dba41b286c9eaa3133ce0db', N'涿鹿县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e67373a37ee9488bae7a5bb20e3d6313', N'双桥区公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e673aaef25fb49b684e8aebf9b26f1be', N'教研室', N'62358ae608e44b9483d58e81f1fb3263', NULL, N'01000000130000001301200013012002')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e6bb75609fa34d56bddcc74c3e1a6414', N'无极中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001357')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e6c76b633d4f4a03bd6efd85f296725a', N'长安区公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001208')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e6d08be515f1469dbe0086c000e6a78f', N'邱县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008234')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e6f15cfbe8b046d286d756daaab1dac0', N'滦平县公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e742890a8fd245eea626f1b4469bfa52', N'高阳县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e7c98880a6ab419aa918df09f006e772', N'指导处', N'2883517c32f547b79eecb8c42363ce91', NULL, N'01000000130000001300004013000041')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e801ceaf8bce45a994a40e2fe0b3682e', N'临漳县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e88cf044307d4526a9eaa47ad37a31de', N'山海关开发区公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009205')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e9151664fb0c47da92056a50be149a90', N'望都县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003230')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e9d0cc8403c74bc69a1287b2132af00a', N'西柏坡中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001368')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e96538b1c89a4036bcc2f7c1be813afe', N'临城县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'e9cef81cc6c64d19985c00246d9bcdee', N'容城县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'9d3a79cbb12d493cb724da23a08f456b', N'武强县消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a03ba17baec4496e88fe085eb886ea89', N'后勤处', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a08128d6d60648839d363513a455ad66', N'景县消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007224')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a09804cf103041519b3a134bfab9ec4a', N'沧州市公安消防支队开发区大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8da5581697ee4086bb577db71208dd1c', N'训练基地', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013114870')GOINSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a0ae115f226148868fe42b9d92d1e40c', N'桥西区公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a116f88b5fab42f1b3811658bad98140', N'桥东区公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b01f1267f5894c9ab27a3cd9930337ab', N'警勤中队', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013000017')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b2f1eadb8a3f4b52bebf318ed9a94e8f', N'司令部', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b3f779a0b22b4e8b8d58a5b87703e8df', N'任县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b4255ef039f443dba4f96d4a537a4252', N'定兴县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003242')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b426d03a207246a18c89bb943c4d3741', N'石家庄市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013001000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b5127c0d7ea845d9ae95b9b0701a3319', N'五中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009305')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b52e1282fea945fab693afd7466d0b04', N'唐山市公安消防支队路南区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002204')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b5e4672e9f654b73a5525f6c4ff55ce7', N'邢台市公安消防支队开发区大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b60b9d91ebcd4c2eaa8b8061e10b7e77', N'文工团', N'283e8fb178864b77baeaf537f4ea1ffa', NULL, N'01000000130000001300002013000025')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b626ced34e7a4ad88cada36f825339d9', N'东光县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011235')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b71f0dcc30094219b5acda4561954b4e', N'安平县消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007230')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b7daeb8a9e484f3d8c5348a38fb6752a', N'司令部', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b8204577d234455b87799004e8580995', N'饶阳县消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007229')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b857f140912d4f84970faf9b2f88ff38', N'大厂回族自治县公安消防大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b8b9eabb1cda4fd9950bb8fa4cba249b', N'门诊部', N'1a8d53170139421fbb20eb22d3e8f674', NULL, N'01000000130000001300003013000038')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3c6d5e6ea3ce46b4bc3ca9cd1f7a5a2a', N'大学城消防站', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013114888')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'9a822fa73a674281901907adff202644', N'宣传处', N'2883517c32f547b79eecb8c42363ce91', NULL, N'01000000130000001300004013114941')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'454210b9e65b4919a2fb9bcec6c7145a', N'搜救犬中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013114949')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'26f6669c950e4aad9db4435324a2b387', N'现役办', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013114902')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f631b47550cc45eba76c47345d4f4e5e', N'红旗北路中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013112215')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd0604f644a2045aeb22eea5ad1b47770', N'沧州市公安消防支队运河区大队学院路中队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013112216')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'dd30c56dfcea4297a8c2e6375c527108', N'战勤保障大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013114943')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b04108ede29e4d6c8fd093debdb115f8', N'办公室', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013114899')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'df37ab61baaf41159231e8a7b7ab9c13', N'纪保督察处', N'283e8fb178864b77baeaf537f4ea1ffa', NULL, N'01000000130000001300002013114900')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ca709c1ca6af4c6c892465ce507aa549', N'审计处', N'283e8fb178864b77baeaf537f4ea1ffa', NULL, N'01000000130000001300002013114901')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8125b0c72fae416ab28250abcdbb0ba3', N'沧州市公安消防支队新华区大队九河路中队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013114916')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'219893de68404b52bc972ed1ca626cef', N'廊坊市公安消防支队培训基地', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013114931')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c357826a22a349128f98f0427082308e', N'承德市公安局钢城分局', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013114950')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd07dd801cf9a45b5a5ee8a36422abc5b', N'辛北分局消防大队', N'92a7ec8b71a949faa1a4c44cad694f70', NULL, N'01000000130000001311200413112957')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'551dca26e24d4e60bd1a2ccae761c53a', N'任南分局消防大队', N'92a7ec8b71a949faa1a4c44cad694f70', NULL, N'01000000130000001311200413112955')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5f002b44620045d0a9cb0f3a79106a17', N'指挥中心', N'ae5a001b754041919c36086fd6d2d501', NULL, N'0100000013000000131BCDH1131BPXN7')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'96d73dc465fd44229719748bad15447b', N'作战一大队', N'ae5a001b754041919c36086fd6d2d501', NULL, N'0100000013000000131BCDH1131BHAQ1')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'69990e33896b4cf9b2d62365ee6940f4', N'政办室', N'907ce3a01f2b4aacb5b4e9350b6cd815', NULL, N'01000000130000001311204213112878')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'28d0e68ff99140bf966d26807ac6e5e0', N'晋州中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013112910')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8547a4ea4ba34d5288d941555bc40685', N'瀛州分局消防大队', N'92a7ec8b71a949faa1a4c44cad694f70', NULL, N'01000000130000001311200413112956')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'cda056c38db54ac0a4eb8d27bf42f956', N'霸西分局消防大队', N'92a7ec8b71a949faa1a4c44cad694f70', NULL, N'01000000130000001311200413112958')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f33f4758c796424abac53d2a1409b600', N'万东分局消防大队', N'92a7ec8b71a949faa1a4c44cad694f70', NULL, N'01000000130000001311200413112959')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8862759e0b354868a24784f52cd22270', N'渤海分局消防大队', N'92a7ec8b71a949faa1a4c44cad694f70', NULL, N'01000000130000001311200413113099')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'62358ae608e44b9483d58e81f1fb3263', N'河北省公安消防总队培训基地', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013012000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'62bb35f36aa740758be88c24a9d31467', N'财务处', N'1a8d53170139421fbb20eb22d3e8f674', NULL, N'01000000130000001300003013000031')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'62f1999928c14deea90bfcc672712439', N'机关党委', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013000018')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'62f7fee82325447a801956a77710d5a9', N'大城县公安消防大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3d1e4b6d1ee744f39617bb6ab61776cc', N'政治处', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'639f1a0d50d5403fbf13ed3d7fd48455', N'消防协会', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013000046')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8081de69f6f640c1bb89d4b14893256d', N'政治处', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007020')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'abfcf2880a8543548e6cf5e6fec22edd', N'警务处', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013000013')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ac737e2ea7f24ff18db5e3c07cba032e', N'司令部', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013000010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ac9a204fe86a4b779bc0cdb9c09191da', N'保定市公安消防支队北市区大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ae0c856b40684bacb7041a2ab9fc8c61', N'防火监督处', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ae4d4e009896404face7e9a93cc30c9a', N'特勤大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008017')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ae890cbfd3a74aa4bbd37d97ed00ea3a', N'辛集市公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001236')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'af7623c7e21c49edbc4a75cbff2395ed', N'开发区公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001206')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'bc6f3d85dd9d44b5b80b847bf3023af4', N'防火监督处', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'bcf028d051ca4b609e4e0f42cf3a1f31', N'盐山县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011234')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'bd14121320864e2193fc1772377f300a', N'邯郸市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013008000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'be2b0276d78a4d91a1fe36c93df92b4c', N'磁县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'be895c06fbcd4650b4805eb739ec6c38', N'滦南县公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'becb9820eb144b46914ad71b5635e189', N'邢台市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013010000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c02617b2ba8842f3ac93b99437832bba', N'正定中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001352')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c02693e2871441b1ae10ae1167cff0ce', N'特勤二中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001315')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c03b6353f1ca46d79b8915487aceb0d6', N'人民东路中队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007303')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c04bf05844844a8d96e30b3c412319ac', N'产品检测站', N'639f1a0d50d5403fbf13ed3d7fd48455', NULL, N'01000000130000001300004613000044')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c223a3bd49b0479bb6485fc356a9eb12', N'清河县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010234')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c2fc847899f64f849eb48b8def94e50f', N'高碑店市公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003239')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c30347155a3346d2b3725e38e92d2173', N'培训基地', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009102')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c3940a6fbf6e462aad8e4274cf72e084', N'矿区公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001205')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'39d5db3968c94fdfa48a4884e6ffd97d', N'山海关开发区中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009307')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3c5fb9b3fa8f4d84bce5cc1aa6c649de', N'唐县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'f9781bfeca7a430a9325d466f1d160ab', N'平山县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3b2391cc4efd4489a7e775a603830fe1', N'新河县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010230')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3b62c29da7ae4439b3d95f199629e70c', N'复兴区公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008203')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3c0f6b4274ba466c9ba9a90dbb8ac122', N'隆化县公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'932d6a42878b4b15b3133571d3a2d174', N'临西县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010235')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'93721e402de54cc08ea3d68335145b59', N'唐山市公安消防支队高新技术产业园区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002207')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'956b149fa37849f3b345cfa9976d1edb', N'满城县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003237')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'961bb3269982418cb1ad10e863cd1768', N'宣化县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'9798fe2bf60c407cab80cc5fae605dba', N'唐山市公安消防支队丰南区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'98f438f08c9d401ab2b34392786b449f', N'站前公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001207')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'994a5893ee8e482da95a689339e0d262', N'辛集中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001351')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'99a7c5433e02461c8e511de294fc9b50', N'三河市公安消防大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'99db694b371d4d13bedb8ea12c00128f', N'后勤处', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'9a2a1d652afb4b2283bdd0ccd5800cac', N'廊坊市公安消防支队东方大学城大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006204')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'cd69131cbdcf48808aaa18dd8bce63a9', N'后勤处', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'edd70189dc124ad9b2e83d387d4f3c22', N'南皮县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011229')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'fd8308b700ad408d9475eb96c4aab7f7', N'组织教育处', N'283e8fb178864b77baeaf537f4ea1ffa', NULL, N'01000000130000001300002013000021')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ff695bddc6ca4e66a504c1bf97b96456', N'栾城中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001359')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'017aa3f88df74015b071b79e30650f35', N'广宗县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010231')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'01f3e682ba4e4340ac3a2b531bf0a6c7', N'开发区消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'02e2c290a8ff48a4979ab19c2bf0a939', N'滦县公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'02f2e9dd3ecc4c96b582c49aa04b2511', N'涞水县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003231')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'02fa482573c145e880d5c7615011f8b1', N'廊坊市公安消防支队安次区大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'045416d0b9574fefbec93e1027c28390', N'廊坊市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013006000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0460f216eccc4a4aba25ddf31d253503', N'四中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009304')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'05b8d324f9a04fb58ce8639c3167de22', N'特勤一中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009303')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'072e898347004b2a9ee6ac1ce5f3170b', N'后勤处', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'076f918f33514e228574be90fd3bf7b7', N'后勤处', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0821650da625407f815cd8b5f5676317', N'峰峰矿区公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'095d92e890334d908077ef078ae552cc', N'一中队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009301')GOINSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd8c8af79a364488eb63658eea13bee63', N'作战指挥中心', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013000011')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'64241517457e468a85473e035faffa72', N'人民西路中队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007315')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6500c242f207485b929f87f3acffb5a9', N'青县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5210fbb33a0842bf90b98590ffedff57', N'和平路中队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007302')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'68bb9327648c4216b0b52c1c92180e5c', N'后勤处', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6925c6f9321f4e0f81f6204b9db22bef', N'火因调查处', N'2883517c32f547b79eecb8c42363ce91', NULL, N'01000000130000001300004013000049')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'6972fcbd396a4ebd85f74d82c0e31580', N'战勤保障大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001102')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'698f2ecd43a34f5f9fbc4614883a98ba', N'孟村回族自治县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011230')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'69d5de3911e94391b3d24a30d0830721', N'献县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'69e1d86337384ec18f242e6f57bcf437', N'蠡县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003235')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1fb1e4a8453c4c15b2205c2e72199325', N'隆尧县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'20e72bbf3c164b0e8e0eaf887a91a6cd', N'唐山市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013002000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'20f2868e7b004e62bcfb94a4433838f1', N'察北管理区', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005236')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'21029a331da44ff9a919507c3829342f', N'肃宁县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011226')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'207c261e7c114213bbe6311a23a50a5c', N'邢台县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'24319c9d9122404ea819aa97ceefa8c9', N'清苑县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003236')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'2455e3abfc414ddbbea2e8bd4dc42b9d', N'防火监督处', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004040')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'24c62b76d0534eb79b154edf2c9d59d8', N'平乡县公安消防大队', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013010232')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'24ec8f8f79714767ab6dc76fa0740c43', N'唐山市公安消防支队芦台经济开发区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002228')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'4f622964383f4db4b7bae7a22c31b2d6', N'阳原县公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'534911a3790144c6b228f3b0831a405f', N'丛台区公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'53499d8526db4bd8b09f07bfca58f759', N'张家口市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013005000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5407ae7e765941088067ad6d97fb619b', N'唐海县公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002230')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'81e8b18a0b3d487f9781a195e7932c93', N'唐山市公安消防支队特勤大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002208')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'820b58a82b8d45148351df21042fc2cd', N'永清县公安消防大队', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013006225')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5450613fabaf4bedbf07b61a9d78b997', N'兴隆县公安消防大队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013004221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'54610d6898ed4dc2bdc49e90c41a04c3', N'昌黎县公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009221')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'54c1cee011764d2b9b63ac4fe553d228', N'迁安市公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'55366c3beb1f48f1bd476b10280b0246', N'北戴河区公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'557a480bd78649b69bc67e3971013c1a', N'魏县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008229')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'574999229cd643cfb8f1dc7b0d304680', N'纪委', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013000023')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'846f8cd122544725bcb8548bfa13ce1e', N'司令部', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0f48a3f3b4514bac9945ffd477b098e4', N'灵寿中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001365')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5864ce5e9c494aeba833db3934d24b56', N'正定县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5904aa5a24fc4ce28a6bd2a456cac7d5', N'肥乡县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008231')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'80fe5f8c79ae4756bb5e8ac4bc626a8b', N'沧州市公安消防支队渤海新区大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011236')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'817b8e5ecbb341869a18ad594347ae3b', N'抚宁县公安消防大队', N'11863a925b9847b2a5aecfd5dc6d0c3c', NULL, N'01000000130000001300900013009222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'83610da5713941fabda5a7c581031684', N'迁西县公安消防大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'84b63437631c4614b0e2cb6d8ec70649', N'广平县公安消防大队', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008232')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0f5ed81afc3547b4bda842459384c37a', N'安国市公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003238')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0f64ea6ebc734a2ba32e20e3a7274176', N'元氏县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001232')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'10e8b6b189bf4309acdee844a95f3aba', N'战训处', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013000012')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd1019fbb37e449fe9b93853c503fad26', N'特勤大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001101')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'11863a925b9847b2a5aecfd5dc6d0c3c', N'秦皇岛市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013009000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1207a8b50ec443218c4e5dc55fb1954b', N'新乐中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001361')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'131c44d725374e7f9be7cda6786d9274', N'无极县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001229')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'135f0bd5a7f84227803e1c520732d5ee', N'桥东区公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001202')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1427eafc2d574cd1a6afd41eea109fbe', N'承德市公安消防支队', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013004000')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1583f0ca391c4c4d80d48eb3f1e35c51', N'八中队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001308')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'169266ab268a43dcb54dcbdd8cdc6181', N'顺平县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003229')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'178cd505fd7e4b95b21bf1e1494de3f3', N'沧州市公安消防支队运河区大队特勤中队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011367')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'183617caea454f688a148f61bd8955fa', N'唐山市公安消防支队汉沽管理区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002229')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'18a81af084984d308e80d4cd3ee1e156', N'司令部', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013008010')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1a8d53170139421fbb20eb22d3e8f674', N'后勤部', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'010000001300000013000030')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1c0ea90ae7fd448599bac1841bdc1392', N'吴桥县公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'01000000130000001301100013011223')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'18cecd4e78884db6b1498274e18d6d40', N'涞源县公安消防大队', N'c4de641495a043db9374ee4c9e354f19', NULL, N'01000000130000001300300013003240')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'18d0cba642e54975858806af12d59525', N'深泽县公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'01000000130000001300100013001227')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1a60e1a2874f477bbdf2fee5596695c7', N'振华新路中队', N'aa340a1b750c48848766e529d1055a54', NULL, N'01000000130000001300700013007304')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'1aea12a635034cfe8921a90844666cd7', N'下花园区公安消防大队', N'53499d8526db4bd8b09f07bfca58f759', NULL, N'01000000130000001300500013005222')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'd0b9be070b7a467090b6b1f9fb7c7753', N'唐山市公安消防支队丰润区大队', N'20e72bbf3c164b0e8e0eaf887a91a6cd', NULL, N'01000000130000001300200013002201')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'b1b4e1c5fef448a2a85a5121a5231bf3', N'冀中公安局消防支队防火监督处', N'92a7ec8b71a949faa1a4c44cad694f70', NULL, N'01000000130000001311200413113100')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'73469bee3fa449a9ac2324423979420b', N'产品检测站', N'2883517c32f547b79eecb8c42363ce91', NULL, N'01000000130000001300004013114625')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'9e47366f0c6b4b708d17a4f5fd252696', N'邢台市公安消防支队培训基地', N'becb9820eb144b46914ad71b5635e189', NULL, N'01000000130000001301000013114726')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'875f39bfbee7480b8b559001aa081135', N'管理处', N'ac737e2ea7f24ff18db5e3c07cba032e', NULL, N'01000000130000001300001013114958')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'7182c95613844fbd8836277e85f720ce', N'培训基地', N'bd14121320864e2193fc1772377f300a', NULL, N'01000000130000001300800013114743')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'3f3ec88ca7a44fa78ca0214e7cbd9ee8', N'战役特别行动队', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013114749')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'5380b7c235f94fe08355163c900fca1d', N'综合办公室', N'045416d0b9574fefbec93e1027c28390', NULL, N'01000000130000001300600013114957')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'37bdab33b6e041719d4ff40d9a45179a', N'培训基地', N'1427eafc2d574cd1a6afd41eea109fbe', NULL, N'01000000130000001300400013114961')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'0d55f396109147b69a01c10448b52046', N'搜救基地调度科', N'ae5a001b754041919c36086fd6d2d501', NULL, N'0100000013000000131BCDH1131BZA6H')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'78f9aafd5d1f4d989beda101982b4398', N'战勤保障大队', N'ae5a001b754041919c36086fd6d2d501', NULL, N'0100000013000000131BCDH1131BGMLE')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'2ae660ed821146fdb3e5bc584bd0bfaf', N'作战二大队', N'ae5a001b754041919c36086fd6d2d501', NULL, N'0100000013000000131BCDH1131B3RWU')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'8d424d53618f48b6878e63fffad7c77f', N'训练处', N'62358ae608e44b9483d58e81f1fb3263', NULL, N'01000000130000001301200013114975')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'a99551dcbdfd43b59b8babe4af8370a7', N'学员队', N'62358ae608e44b9483d58e81f1fb3263', NULL, N'01000000130000001301200013114978')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'bfe2ea919fc24c3ca600a5ad543eaba7', N'高新区公安消防大队', N'4cbf60d35d3c47a2af3de7b9ea6a93b1', NULL, N'010000001300000013011000131B0T58')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'c2410906e5d44ad5a29dc6dcd60decd7', N'滨湖新区消防大队', N'aa340a1b750c48848766e529d1055a54', NULL, N'010000001300000013007000131B63P9')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'fe8a251ae3f04321a6cfc2e8a98f50a9', N'正定新区公安消防大队', N'b426d03a207246a18c89bb943c4d3741', NULL, N'010000001300000013001000131B9G2F')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'626d0115ff8c485abbf99e26ff0b5179', N'现役纪委', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'0100000013000000131B5LF6')INSERT [dbo].[t_sys_zzjg] ([zzjg_id], [zzmc], [sjzzjg_id], [xh], [jgtree]) VALUES (N'ae5a001b754041919c36086fd6d2d501', N'陆地搜救基地', N'384df1110cd84797a6ebd3ef3d5d2e30', NULL, N'0100000013000000131BCDH1')

再分别执行以下两个查询

第一个：

SELECT * FROM (SELECT DISTINCT ssrwid FROM v_gzrw_zzjg) A OUTER APPLY(         SELECT [zzmc]= STUFF(REPLACE(REPLACE(             (                 SELECT zzmc FROM v_gzrw_zzjg N                 WHERE ssrwid = A.ssrwid                 FOR XML AUTO             ), '<N zzmc="', ','), '"/>', ''), 1, 1, '') ) N

第二个：

select DISTINCT x.ssrwid,x.zzmc from (SELECT  ssrwid,ssjgid,                    zzmc=stuff(                                (SELECT ';'+zzmc                                FROM                                    (SELECT z2.zzmc,z1.*                                    FROM t_rw_gzrw_zzjg z1,t_sys_zzjg z2                                    WHERE z1.ssjgid = z2.zzjg_id) tt                                WHERE tt.ssrwid=t.ssrwid                                    FOR xml path('')), 1, 1, '')            FROM                (SELECT z2.zzmc,                        z1.*                FROM t_rw_gzrw_zzjg z1,                    t_sys_zzjg z2                WHERE z1.ssjgid = z2.zzjg_id) t) x

效果如下图
本人sql server 2014 亲测。