字符串聚合问题

mingqing6364 2016-08-22 07:44:06

今天遇到一个问题
两个函数里面分别用WITH CTE取出完全一致的临时数据
然后用SELECT @STR=@STR+STR FROM CTE聚合字符串
得到的结果居然不同
而且这个现象必须是在达到一定数据量时才会发生
帖子篇幅所限
这里先贴出表、视图、函数的创建SQL，测试数据我会回复在后面

测试环境搭建：
创建表：



CREATE TABLE [dbo].[T1] 

(

[HH] smallint NOT NULL ,

[CFWZ] varchar(20) NULL 

);

CREATE TABLE [dbo].[T2] 

(

[ID] int NOT NULL ,

[SLBH] varchar(20) NULL ,

[HH] smallint NULL 

);

CREATE TABLE [dbo].[T3]

 (

[ID] int NOT NULL ,

[XH] smallint NOT NULL ,

[FN] varchar(80) NULL 

);

CREATE TABLE [dbo].[T4]

 (

[ID] int NOT NULL ,

[SSID] int NOT NULL 

)

创建视图：



CREATE VIEW [dbo].[V1] AS 

SELECT

	T2.ID,

	T2.SLBH,

	T2.HH,

	CASE

		WHEN ISNULL(T1.CFWZ,'') <> '' THEN T1.CFWZ + '-' + CAST(T2.HH AS VARCHAR(50))

		WHEN ISNULL(T2.HH,0) <> 0 THEN CAST(T2.HH AS VARCHAR(50))

		ELSE ''

	END AS 'CFWZ',

	T3.XH,

	T3.FN

FROM

	T2

	LEFT JOIN T1 ON T1.HH = T2.HH

	LEFT JOIN T3 ON T3.ID = T2.ID

创建函数F1：



CREATE FUNCTION [dbo].[F1]

( @ID AS int 

)

RETURNS NVARCHAR(MAX)

AS

BEGIN

	DECLARE @HTML NVARCHAR(MAX) = '<div class="easyui-accordion" data-options="fit:false,border:false">' + CHAR(13) + CHAR(10);



	WITH

	SS AS

		(

				SELECT

					ID IDA,

					SSID AS IDB,

					-1 AS DGCS,

					CAST(@ID AS VARCHAR(MAX)) + '-' + CAST(ID AS VARCHAR(10)) AS PX

				FROM T4 WHERE ID = @ID

			UNION ALL

				SELECT

					B.ID IDA,

					B.SSID AS IDB,

					A.DGCS - 1,

					A.PX + '-' + CAST(B.ID AS VARCHAR(10))

				FROM SS AS A INNER JOIN T4 AS B ON A.IDB = B.ID

		),

	XS AS

		(

				SELECT

					SSID IDA,

					ID AS IDB,

					1 AS DGCS,

					CAST(@ID AS VARCHAR(MAX)) + '-' + CAST(ID AS VARCHAR(10)) AS PX

				FROM T4 WHERE SSID = @ID

			UNION ALL

				SELECT

					B.SSID IDA,

					B.ID AS IDB,

					A.DGCS + 1,

					A.PX + '-' + CAST(B.ID AS VARCHAR(10))

				FROM XS AS A INNER JOIN T4 AS B ON A.IDB = B.SSID

		),

	SXS AS

		(

			SELECT *,0 - ROW_NUMBER() OVER(ORDER BY PX ASC) AS PX2 FROM SS

			UNION ALL

			SELECT *,ROW_NUMBER() OVER(ORDER BY PX ASC) AS PX2 FROM XS

			UNION ALL

			SELECT @ID,@ID,0,CAST(@ID AS VARCHAR(10)),0

		),

	HTML AS

		(

			SELECT

				'	<div title="' + CASE WHEN SXS.DGCS < 0 THEN '(-' + CAST( - SXS.DGCS AS VARCHAR(5)) + ')' WHEN SXS.DGCS > 0 THEN '(+' + CAST(SXS.DGCS AS VARCHAR(5)) + ')' ELSE '' END + V1.FN + '" data-options="collapsed:false,collapsible:false" style="padding:10px;">' + CHAR(13) + CHAR(10) +

				'		<A ' + CASE WHEN SXS.DGCS = 0 THEN 'disabled' ELSE '' END + ' class="easyui-linkbutton" href="http://index.php?id=' + CAST(SXS.IDB AS VARCHAR(10)) + '">' + V1.CFWZ + '-' + REPLACE(CAST(SXS.IDB AS VARCHAR(10)), '-', 'Z') + '</A>' + CHAR(13) + CHAR(10) +

				'		<A ' + CASE WHEN ISNULL(V1.SLBH,'') = '' THEN 'disabled' ELSE '' END + ' class="easyui-linkbutton" target="_blank" href="http://InteQueryList.aspx?keycode=' + V1.SLBH + '">LINKA</A>' + CHAR(13) + CHAR(10) +

				'		<A class="easyui-linkbutton" target="_blank" href="http://pic.php?ajh=' + CAST(SXS.IDB AS VARCHAR(10)) + '">LINKB</A>' + CHAR(13) + CHAR(10) +

				'	</div>' + CHAR(13) + CHAR(10) AS HTML,

				SXS.PX2

			FROM

				SXS LEFT JOIN V1 ON SXS.IDB = V1.ID AND V1.XH = 1

		)

		

	SELECT @HTML = @HTML + HTML FROM HTML ORDER BY PX2 ASC



	SET @HTML = @HTML + '</div>'



	RETURN @HTML

END

创建函数F2：



CREATE FUNCTION [dbo].[F2]

( @ID AS int 

)

RETURNS NVARCHAR(MAX)

AS

BEGIN

	DECLARE @HTML NVARCHAR(MAX) = '<div class="easyui-accordion" data-options="fit:false,border:false">' + CHAR(13) + CHAR(10);



	WITH

	SS AS

		(

				SELECT

					ID IDA,

					SSID AS IDB,

					-1 AS DGCS,

					CAST(@ID AS VARCHAR(MAX)) + '-' + CAST(ID AS VARCHAR(10)) AS PX

				FROM T4 WHERE ID = @ID

			UNION ALL

				SELECT

					B.ID IDA,

					B.SSID AS IDB,

					A.DGCS - 1,

					A.PX + '-' + CAST(B.ID AS VARCHAR(10))

				FROM SS AS A INNER JOIN T4 AS B ON A.IDB = B.ID

		),

	XS AS

		(

				SELECT

					SSID IDA,

					ID AS IDB,

					1 AS DGCS,

					CAST(@ID AS VARCHAR(MAX)) + '-' + CAST(ID AS VARCHAR(10)) AS PX

				FROM T4 WHERE SSID = @ID

			UNION ALL

				SELECT

					B.SSID IDA,

					B.ID AS IDB,

					A.DGCS + 1,

					A.PX + '-' + CAST(B.ID AS VARCHAR(10))

				FROM XS AS A INNER JOIN T4 AS B ON A.IDB = B.SSID

		),

	SXS AS

		(

			SELECT *,0 - ROW_NUMBER() OVER(ORDER BY PX ASC) AS PX2 FROM SS

			UNION ALL

			SELECT *,ROW_NUMBER() OVER(ORDER BY PX ASC) AS PX2 FROM XS

			UNION ALL

			SELECT @ID,@ID,0,CAST(@ID AS VARCHAR(10)),0

		),

	QSJ AS

		(

			SELECT

				SXS.IDB AS ID,

				SXS.DGCS,

				CASE WHEN SXS.DGCS < 0 THEN '(-' + CAST( - SXS.DGCS AS VARCHAR(5)) + ')' WHEN SXS.DGCS > 0 THEN '(+' + CAST(SXS.DGCS AS VARCHAR(5)) + ')' ELSE '' END + T3.FN AS BT,

				ISNULL(T1.CFWZ + '-', '') + REPLACE(T1.HH, '-', 'Z') + '-' + REPLACE(CAST(SXS.IDB AS VARCHAR(10)), '-', 'Z') AS CFWZ,

				T2.SLBH,

				SXS.PX2

			FROM

				SXS LEFT JOIN T2 ON SXS.IDB = T2.ID

				LEFT JOIN T1 ON T2.HH = T1.HH

				LEFT JOIN T3 ON SXS.IDB = T3.ID AND T3.XH = 1

		),

	HTML AS

		(

			SELECT

				'	<div title="' + BT + '" data-options="collapsed:false,collapsible:false" style="padding:10px;">' + CHAR(13) + CHAR(10) +

				'		<A ' + CASE WHEN DGCS = 0 THEN 'disabled' ELSE '' END + ' class="easyui-linkbutton" href="http://index.php?id=' + CAST(ID AS VARCHAR(10)) + '">' + CFWZ + '</A>' + CHAR(13) + CHAR(10) +

				'		<A ' + CASE WHEN ISNULL(SLBH,'') = '' THEN 'disabled' ELSE '' END + ' class="easyui-linkbutton" target="_blank" href="http://InteQueryList.aspx?keycode=' + SLBH + '">LINKA</A>' + CHAR(13) + CHAR(10) +

				'		<A class="easyui-linkbutton" target="_blank" href="http://pic.php?ajh=' + CAST(ID AS VARCHAR(10)) + '">LINKB</A>' + CHAR(13) + CHAR(10) +

				'	</div>' + CHAR(13) + CHAR(10) AS HTML,

				PX2

			FROM

				QSJ

		)

		

	SELECT @HTML = @HTML + HTML FROM HTML ORDER BY PX2 ASC



	SET @HTML = @HTML + '</div>'



	RETURN @HTML

END

最后，测试语句：

SELECT dbo.F1(93617),dbo.F2(93617)

可以发现F1和F2的返回值不同
我单独把F1和F2中的with部分拿出
得到的结果集是完全一致的

...全文

285 19 打赏收藏转发到动态举报

写回复

用AI写文章

19 条回复

切换为时间正序

请发表友善的回复…

发表回复

jesons 2016-08-23

打赏
举报

学习了，谢谢！！

中国风 2016-08-23

打赏
举报

不改神力可这样处理把F1函数条件改为 AND V1.XH = 1 改为 AND (V1.XH = 1 OR V1.XH IS NULL)

中国风 2016-08-23

打赏
举报

视图在T3加上条件AND T3.XH = 1


CREATE VIEW [dbo].[V1] AS 
SELECT
	T2.ID,
	T2.SLBH,
	T2.HH,
	CASE
		WHEN ISNULL(T1.CFWZ,'') <> '' THEN T1.CFWZ + '-' + CAST(T2.HH AS VARCHAR(50))
		WHEN ISNULL(T2.HH,0) <> 0 THEN CAST(T2.HH AS VARCHAR(50))
		ELSE ''
	END AS 'CFWZ',
	T3.XH,
	T3.FN
FROM
	T2
	LEFT JOIN T1 ON T1.HH = T2.HH
	LEFT JOIN T3 ON T3.ID = T2.ID  AND T3.XH = 1

[dbo].[F1] 去掉AND V1.XH = 1 在函数里加影响整个结果集，问题出在这

mingqing6364 2016-08-23

打赏
举报

TO：#4 两个函数最后都是以HTML AS结尾我单独拿出WITH到HTML AS这部分，再加上个select * from HTML 发现得到的结果集是完全一致的但是写到函数里面，后面接同样的聚集函数，聚集出来的结果却不同我已经把语句都整理好了，你可以搭建一个环境测试一下

卖水果的net 2016-08-23

打赏
举报

你是说两个函数的功能不一样吗？看样子，这个逻辑确实是不一样的， F2 多了 QSJ 这个；

mingqing6364 2016-08-23

打赏
举报

TO：#15、#16、#17 我认真检查过了，我给出的例子中不包含NULL的情况，即使各个表LEFT JOIN之后也没有NULL 花了半个下午的时间，把两个函数中的WITH HTML部分一段一段的删减，最后锁定问题出在REPLACE()部分谢谢你花费宝贵的时间帮我解答

mingqing6364 2016-08-23

打赏
举报

TO：所有人已经明白了，是REPLACE(HH,'-','Z')出的问题 RELPACE（）的第一个参数被我填入了int类型这个写法在查询中不会有问题，但是在SQL SERVER函数中会出问题具体的列子可以参看我的博客http://blog.csdn.net/mingqing6364/article/details/52291580 最后感谢所有看帖回帖的朋友

中国风 2016-08-23

打赏
举报

给你两种写法举个例子,如果你继续坚持你的两种写法一样，你就当作哥没讲过就行了

e.g.

CREATE TABLE T1(ID INT);INSERT INTO dbo.T1
        ( ID )
VALUES  ( 1  -- ID - int
          );
go
CREATE TABLE T2(ID INT,ID2 INT);INSERT INTO dbo.T2
        ( ID,ID2 )
VALUES  ( 1,0  -- ID - int
          )
go
CREATE TABLE T3(ID INT);INSERT INTO dbo.T3
        ( ID )
VALUES  ( 1  -- ID - int
          );
GO

CREATE VIEW v1
AS
SELECT 
	T1.ID,T2.ID2
FROM dbo.T1 
	LEFT JOIN T2 ON T1.ID=T2.ID
GO

SELECT
	v1.ID
FROM dbo.T3
	LEFT JOIN dbo.v1 ON v1.ID = T3.ID AND v1.ID2=1

/*--T1.ID
ID	
NULL	
*/


SELECT
	T1.ID
FROM T3 
	LEFT JOIN T1 ON T1.ID=T3.ID
	LEFT JOIN T2 ON T2.ID=T1.ID AND t2.ID2=1
/*--T1.ID
ID	
1	
*/

中国风 2016-08-23

打赏
举报

你两种写法视图和语句效果不致，需要给你举个例子你才会明白么？

按照上面改就对了

中国风 2016-08-23

打赏
举报

SET @str=(SELECT [str] from [TABLE]  FOR XML PATH(''))



select @str=@str+ISNULL(str,'') from TABLE

你所说的有问题，有null时会存在，用isnull处理

mingqing6364 2016-08-23

打赏
举报

TO：#11 我将F1中的with和F2中的with单独拿出，后接一条SELECT * INTO RF1 FROM HTML，然后对比结果集，完全一致具体实现SQL如下：将F1中的WITH拿出，@ID替换成93617，结尾加上SELECT * INTO RF1 FROM HTML


	WITH
	SS AS
		(
				SELECT
					ID IDA,
					SSID AS IDB,
					-1 AS DGCS,
					CAST(93617 AS VARCHAR(MAX)) + '-' + CAST(ID AS VARCHAR(10)) AS PX
				FROM T4 WHERE ID = 93617
			UNION ALL
				SELECT
					B.ID IDA,
					B.SSID AS IDB,
					A.DGCS - 1,
					A.PX + '-' + CAST(B.ID AS VARCHAR(10))
				FROM SS AS A INNER JOIN T4 AS B ON A.IDB = B.ID
		),
	XS AS
		(
				SELECT
					SSID IDA,
					ID AS IDB,
					1 AS DGCS,
					CAST(93617 AS VARCHAR(MAX)) + '-' + CAST(ID AS VARCHAR(10)) AS PX
				FROM T4 WHERE SSID = 93617
			UNION ALL
				SELECT
					B.SSID IDA,
					B.ID AS IDB,
					A.DGCS + 1,
					A.PX + '-' + CAST(B.ID AS VARCHAR(10))
				FROM XS AS A INNER JOIN T4 AS B ON A.IDB = B.SSID
		),
	SXS AS
		(
			SELECT *,0 - ROW_NUMBER() OVER(ORDER BY PX ASC) AS PX2 FROM SS
			UNION ALL
			SELECT *,ROW_NUMBER() OVER(ORDER BY PX ASC) AS PX2 FROM XS
			UNION ALL
			SELECT 93617,93617,0,CAST(93617 AS VARCHAR(10)),0
		),
	HTML AS
		(
			SELECT
				'	<div title="' + CASE WHEN SXS.DGCS < 0 THEN '(-' + CAST( - SXS.DGCS AS VARCHAR(5)) + ')' WHEN SXS.DGCS > 0 THEN '(+' + CAST(SXS.DGCS AS VARCHAR(5)) + ')' ELSE '' END + V1.FN + '" data-options="collapsed:false,collapsible:false" style="padding:10px;">' + CHAR(13) + CHAR(10) +
				'		<A ' + CASE WHEN SXS.DGCS = 0 THEN 'disabled' ELSE '' END + ' class="easyui-linkbutton" href="http://index.php?id=' + CAST(SXS.IDB AS VARCHAR(10)) + '">' + V1.CFWZ + '-' + REPLACE(CAST(SXS.IDB AS VARCHAR(10)), '-', 'Z') + '</A>' + CHAR(13) + CHAR(10) +
				'		<A ' + CASE WHEN ISNULL(V1.SLBH,'') = '' THEN 'disabled' ELSE '' END + ' class="easyui-linkbutton" target="_blank" href="http://InteQueryList.aspx?keycode=' + V1.SLBH + '">LINKA</A>' + CHAR(13) + CHAR(10) +
				'		<A class="easyui-linkbutton" target="_blank" href="http://pic.php?ajh=' + CAST(SXS.IDB AS VARCHAR(10)) + '">LINKB</A>' + CHAR(13) + CHAR(10) +
				'	</div>' + CHAR(13) + CHAR(10) AS HTML,
				SXS.PX2
			FROM
				SXS LEFT JOIN V1 ON SXS.IDB = V1.ID AND V1.XH = 1
		)

SELECT * INTO RF1 FROM HTML

将F2中的WITH拿出，@ID替换成93617，结尾加上SELECT * INTO RF2 FROM HTML

	WITH
	SS AS
		(
				SELECT
					ID IDA,
					SSID AS IDB,
					-1 AS DGCS,
					CAST(93617 AS VARCHAR(MAX)) + '-' + CAST(ID AS VARCHAR(10)) AS PX
				FROM T4 WHERE ID = 93617
			UNION ALL
				SELECT
					B.ID IDA,
					B.SSID AS IDB,
					A.DGCS - 1,
					A.PX + '-' + CAST(B.ID AS VARCHAR(10))
				FROM SS AS A INNER JOIN T4 AS B ON A.IDB = B.ID
		),
	XS AS
		(
				SELECT
					SSID IDA,
					ID AS IDB,
					1 AS DGCS,
					CAST(93617 AS VARCHAR(MAX)) + '-' + CAST(ID AS VARCHAR(10)) AS PX
				FROM T4 WHERE SSID = 93617
			UNION ALL
				SELECT
					B.SSID IDA,
					B.ID AS IDB,
					A.DGCS + 1,
					A.PX + '-' + CAST(B.ID AS VARCHAR(10))
				FROM XS AS A INNER JOIN T4 AS B ON A.IDB = B.SSID
		),
	SXS AS
		(
			SELECT *,0 - ROW_NUMBER() OVER(ORDER BY PX ASC) AS PX2 FROM SS
			UNION ALL
			SELECT *,ROW_NUMBER() OVER(ORDER BY PX ASC) AS PX2 FROM XS
			UNION ALL
			SELECT 93617,93617,0,CAST(93617 AS VARCHAR(10)),0
		),
	QSJ AS
		(
			SELECT
				SXS.IDB AS ID,
				SXS.DGCS,
				CASE WHEN SXS.DGCS < 0 THEN '(-' + CAST( - SXS.DGCS AS VARCHAR(5)) + ')' WHEN SXS.DGCS > 0 THEN '(+' + CAST(SXS.DGCS AS VARCHAR(5)) + ')' ELSE '' END + T3.FN AS BT,
				ISNULL(T1.CFWZ + '-', '') + REPLACE(T1.HH, '-', 'Z') + '-' + REPLACE(CAST(SXS.IDB AS VARCHAR(10)), '-', 'Z') AS CFWZ,
				T2.SLBH,
				SXS.PX2
			FROM
				SXS LEFT JOIN T2 ON SXS.IDB = T2.ID
				LEFT JOIN T1 ON T2.HH = T1.HH
				LEFT JOIN T3 ON SXS.IDB = T3.ID AND T3.XH = 1
		),
	HTML AS
		(
			SELECT
				'	<div title="' + BT + '" data-options="collapsed:false,collapsible:false" style="padding:10px;">' + CHAR(13) + CHAR(10) +
				'		<A ' + CASE WHEN DGCS = 0 THEN 'disabled' ELSE '' END + ' class="easyui-linkbutton" href="http://index.php?id=' + CAST(ID AS VARCHAR(10)) + '">' + CFWZ + '</A>' + CHAR(13) + CHAR(10) +
				'		<A ' + CASE WHEN ISNULL(SLBH,'') = '' THEN 'disabled' ELSE '' END + ' class="easyui-linkbutton" target="_blank" href="http://InteQueryList.aspx?keycode=' + SLBH + '">LINKA</A>' + CHAR(13) + CHAR(10) +
				'		<A class="easyui-linkbutton" target="_blank" href="http://pic.php?ajh=' + CAST(ID AS VARCHAR(10)) + '">LINKB</A>' + CHAR(13) + CHAR(10) +
				'	</div>' + CHAR(13) + CHAR(10) AS HTML,
				PX2
			FROM
				QSJ
		)

SELECT * INTO RF2 FROM HTML

对比RF1，RF2，结果为空，说明两个函数中的HTML是完全一致的结果

SELECT
	dbo.RF1.HTML,
	dbo.RF1.PX2,
	dbo.RF2.HTML,
	dbo.RF2.PX2
FROM
	dbo.RF1,dbo.RF2 
WHERE
	dbo.RF1.PX2 = dbo.RF2.PX2
AND
	ISNULL(dbo.RF1.HTML,'RF1') <> ISNULL(dbo.RF2.HTML,'RF2')

mingqing6364 2016-08-23

打赏
举报

TO：#10 先不讨论临时表的问题，通过CTE已经有办法得到我认为正确的结果我现在比较疑惑的是，同样的输入（with中的HTML）、同样的方法（select @str=@str+str from table），居然会得到不同的结果希望能帮我分析原因 TO：所有人据我所知：SQL SERVER官方没有提供字符串的聚合函数以我目前掌握的知识，聚合字符串的方法基本就是UPDATE临时表、select @str=@str+str from table、FOR XML update临时表不能指定聚合的顺序，存在随机性 FOR XML要多次replace，我实践的也不多比较方便写入到函数、存储过程中的就是select @str=@str+str from table 但是现在貌似这个方法出了问题，而且我还没有能力找到问题出在哪里用起来挺提心吊胆的

中国风 2016-08-23

打赏
举报

直接影响T1/T2的本栏位判断以下这一段

CASE WHEN SXS.DGCS < 0 THEN '(-' + CAST( - SXS.DGCS AS VARCHAR(5)) + ')' WHEN SXS.DGCS > 0 THEN '(+' + CAST(SXS.DGCS AS VARCHAR(5)) + ')' ELSE '' END + T3.FN AS BT,
                ISNULL(T1.CFWZ + '-', '') + REPLACE(T1.HH, '-', 'Z') + '-' + REPLACE(CAST(SXS.IDB AS VARCHAR(10)), '-', 'Z') AS CFWZ,
                T2.SLBH,

中国风 2016-08-23

打赏
举报

引用 9 楼 mingqing6364 的回复:

TO：#6、#7 按#6与#7修改测试，所得结果与修改前一致同时说明几点问题： 1）测试数据中，T2中存在的ID，在T3中一定有一个对应的ID，且XH = 1（不等于1的都被我删掉了，不影响测试结果） 2）两个函数F1、F2中with HTML结果集是一致的，至少单独拿出with HTML到查询中得到的记录集是完全一致的 3）with HTML中应该会有251条记录，我通过同样的SQL语句聚集这些记录中的HTML字段，所得的结果居然不一致，这就是令我疑惑的地方，希望能得到解答。 4）F1应该是把251条记录完整的聚合起来了，F2仅仅聚合了最后一条记录，F1得出的结果才是我认为正确的结果

不可能一致，当T3.XH != 1，没有1的情况结果集时会不一致

LongRui888 2016-08-23

打赏
举报

最好是把数据先放到临时表里，然后再计算。之前在拆分数据时，就用问题，之所以有这样的问题是由于执行计划改变的原因，所以必须要先放大到临时表，然后再去把字符串进行聚合

mingqing6364 2016-08-23

打赏
举报

TO：#6、#7 按#6与#7修改测试，所得结果与修改前一致同时说明几点问题： 1）测试数据中，T2中存在的ID，在T3中一定有一个对应的ID，且XH = 1（不等于1的都被我删掉了，不影响测试结果） 2）两个函数F1、F2中with HTML结果集是一致的，至少单独拿出with HTML到查询中得到的记录集是完全一致的 3）with HTML中应该会有251条记录，我通过同样的SQL语句聚集这些记录中的HTML字段，所得的结果居然不一致，这就是令我疑惑的地方，希望能得到解答。 4）F1应该是把251条记录完整的聚合起来了，F2仅仅聚合了最后一条记录，F1得出的结果才是我认为正确的结果

mingqing6364 2016-08-22

打赏
举报

向T4插入数据：


INSERT INTO [test].[dbo].[T4] ([ID], [SSID]) VALUES 
 ('336536', '93617') ,
 ('336537', '93617') ,
 ('336538', '93617') ,
 ('336539', '93617') ,
 ('338538', '93617') ,
 ('338539', '93617') ,
 ('338540', '93617') ,
 ('338541', '93617') ,
 ('338542', '93617') ,
 ('338543', '93617') ,
 ('338544', '93617') ,
 ('338545', '93617') ,
 ('339746', '93617') ,
 ('339747', '93617') ,
 ('339907', '93617') ,
 ('339908', '93617') ,
 ('339909', '93617') ,
 ('339910', '93617') ,
 ('339911', '93617') ,
 ('339912', '93617') ,
 ('339913', '93617') ,
 ('339914', '93617') ,
 ('339915', '93617') ,
 ('339916', '93617') ,
 ('339917', '93617') ,
 ('339918', '93617') ,
 ('339919', '93617') ,
 ('339920', '93617') ,
 ('339921', '93617') ,
 ('339922', '93617') ,
 ('339923', '93617') ,
 ('339924', '93617') ,
 ('339925', '93617') ,
 ('339926', '93617') ,
 ('339927', '93617') ,
 ('339928', '93617') ,
 ('339929', '93617') ,
 ('339930', '93617') ,
 ('339931', '93617') ,
 ('339932', '93617') ,
 ('339933', '93617') ,
 ('339934', '93617') ,
 ('339935', '93617') ,
 ('339936', '93617') ,
 ('339937', '93617') ,
 ('339938', '93617') ,
 ('339939', '93617') ,
 ('339940', '93617') ,
 ('339941', '93617') ,
 ('339942', '93617') ,
 ('339943', '93617') ,
 ('342740', '334094') ,
 ('343024', '93617') ,
 ('343029', '93617') ,
 ('343030', '93617') ,
 ('343031', '93617') ,
 ('343032', '93617') ,
 ('343033', '93617') ,
 ('343034', '93617') ,
 ('343045', '93617') ,
 ('343046', '93617') ,
 ('343047', '93617') ,
 ('343048', '93617') ,
 ('343049', '93617') ,
 ('343050', '93617') ,
 ('343051', '93617') ,
 ('343052', '93617') ,
 ('343053', '93617') ,
 ('343054', '93617') ,
 ('343055', '93617') ,
 ('343056', '93617') ,
 ('344246', '93617') ,
 ('344247', '93617') ,
 ('344248', '93617') ,
 ('344249', '93617') ,
 ('344250', '93617') ,
 ('344253', '93617') ,
 ('344254', '93617') ,
 ('344255', '93617') ,
 ('344258', '93617') ,
 ('344259', '93617') ,
 ('344260', '93617') ,
 ('344306', '93617') ,
 ('344307', '93617') ,
 ('344310', '93617') ,
 ('344311', '93617') ,
 ('344312', '93617') ,
 ('344313', '93617') ,
 ('344314', '93617') ,
 ('344315', '93617') ,
 ('344316', '93617') ,
 ('344317', '93617') ,
 ('344318', '93617') ,
 ('344319', '93617') ,
 ('344320', '93617') ,
 ('344321', '93617') ,
 ('344322', '93617') ,
 ('344323', '93617') ,
 ('344506', '93617') ,
 ('344507', '93617') ,
 ('344508', '93617') ,
 ('344509', '93617') ,
 ('344510', '93617') ,
 ('344511', '93617') ,
 ('344512', '93617') ,
 ('344513', '93617') ,
 ('344514', '93617') ,
 ('344515', '93617') ,
 ('344516', '93617') ,
 ('344517', '93617') ,
 ('344518', '93617') ,
 ('344519', '93617') ,
 ('344520', '93617') ,
 ('344521', '93617') ,
 ('344522', '93617') ,
 ('344523', '93617') ,
 ('344524', '93617') ,
 ('344527', '93617') ,
 ('344528', '93617') ,
 ('344529', '93617') ,
 ('344530', '93617') ,
 ('344531', '93617') ,
 ('344532', '93617') ,
 ('344533', '93617') ,
 ('344788', '93617') ,
 ('344789', '93617') ,
 ('344790', '93617') ,
 ('344791', '93617') ,
 ('344792', '93617') ,
 ('344793', '93617') ,
 ('344794', '93617') ,
 ('344795', '93617') ,
 ('344796', '93617') ,
 ('344797', '93617') ,
 ('344798', '93617') ,
 ('344799', '93617') ,
 ('344800', '93617') ,
 ('344801', '93617') ,
 ('344802', '93617') ,
 ('344803', '93617') ,
 ('344804', '93617') ,
 ('344805', '93617') ,
 ('344806', '93617') ,
 ('344807', '93617') ,
 ('344808', '93617') ,
 ('344809', '93617') ,
 ('344810', '93617') ,
 ('344811', '93617') ,
 ('344812', '93617') ,
 ('344813', '93617') ,
 ('344814', '93617') ,
 ('344815', '93617') ,
 ('344816', '93617') ,
 ('344817', '93617') ,
 ('344818', '93617') ,
 ('344819', '93617') ,
 ('344820', '93617') ,
 ('344821', '93617') ,
 ('344833', '93617') ,
 ('345089', '93617') ,
 ('345091', '93617') ,
 ('349248', '344833') ,
 ('349279', '335040') ,
 ('349942', '93617') ,
 ('349943', '93617') ,
 ('349944', '93617') ,
 ('349945', '93617') ,
 ('349946', '93617') ,
 ('349947', '93617') ,
 ('352061', '93617') ,
 ('352062', '93617') ,
 ('352063', '93617') ,
 ('352064', '93617') ,
 ('352065', '93617') ,
 ('352066', '93617') ,
 ('352067', '93617') ,
 ('352068', '93617') ,
 ('352069', '93617') ,
 ('352070', '93617') ,
 ('352072', '93617') ,
 ('352073', '93617') ,
 ('352074', '93617') ,
 ('352075', '93617') ,
 ('352076', '93617') ,
 ('352077', '93617') ,
 ('352085', '93617') ,
 ('352092', '93617') ,
 ('352093', '93617') ,
 ('352094', '93617') ,
 ('352095', '93617') ,
 ('352096', '93617') ,
 ('352097', '93617') ,
 ('352098', '93617') ,
 ('352099', '93617') ,
 ('352100', '93617') ,
 ('352101', '93617') ,
 ('352102', '93617') ,
 ('352103', '93617') ,
 ('352104', '93617') ,
 ('352105', '93617') ,
 ('352106', '93617') ,
 ('352107', '93617') ,
 ('352108', '93617') ,
 ('352109', '93617') ,
 ('352318', '93617') ,
 ('352353', '336002') ,
 ('352580', '333835') ,
 ('352581', '335043') ,
 ('353068', '93617') ,
 ('353574', '93617') ,
 ('353575', '93617') ,
 ('353576', '93617') ,
 ('353577', '93617') ,
 ('353578', '93617') ,
 ('353579', '93617') ,
 ('353580', '93617') ,
 ('353581', '93617') ,
 ('353582', '93617') ,
 ('353583', '93617') ,
 ('355176', '93617') ,
 ('355177', '93617') ,
 ('355178', '93617') ,
 ('355180', '93617') ,
 ('355290', '333845') ,
 ('355294', '335036') ,
 ('358612', '334098') ,
 ('359432', '334083') ,
 ('359518', '93617') ,
 ('360823', '333829') ,
 ('362814', '93617') ,
 ('362815', '93617') ,
 ('362816', '93617') ,
 ('362817', '93617') ,
 ('362818', '93617') ,
 ('362819', '93617') ,
 ('362820', '93617') ,
 ('362821', '93617') ,
 ('362822', '93617') ,
 ('362823', '93617') ,
 ('362824', '93617') ,
 ('362825', '93617') ,
 ('362826', '93617') ,
 ('362827', '93617') ,
 ('362828', '93617') ,
 ('362829', '93617') ,
 ('362831', '93617') ,
 ('362832', '93617') ,
 ('362833', '93617') ,
 ('362842', '93617') ,
 ('362843', '93617') ,
 ('362844', '93617') ,
 ('362845', '93617') ,
 ('362846', '93617') ,
 ('362848', '93617') ,
 ('362849', '93617') ,
 ('362850', '93617') ,
 ('362851', '93617') ,
 ('362852', '93617') ,
 ('362865', '93617') ,
 ('362866', '93617')

mingqing6364 2016-08-22

打赏
举报

向T3插入数据：


INSERT INTO [test].[dbo].[T3] ([ID], [XH], [FN]) VALUES 
 ('93617', '1', '赣') ,
 ('333829', '1', '赖') ,
 ('333835', '1', '王') ,
 ('333845', '1', '刘') ,
 ('334083', '1', '曾') ,
 ('334094', '1', '张') ,
 ('334098', '1', '张') ,
 ('335036', '1', '王') ,
 ('335040', '1', '黄') ,
 ('335043', '1', '王') ,
 ('336002', '1', '叶') ,
 ('336536', '1', '卢') ,
 ('336537', '1', '张') ,
 ('336538', '1', '张') ,
 ('336539', '1', '邹') ,
 ('338538', '1', '邓') ,
 ('338539', '1', '李') ,
 ('338540', '1', '胡') ,
 ('338541', '1', '袁') ,
 ('338542', '1', '张') ,
 ('338543', '1', '刘') ,
 ('338544', '1', '饶') ,
 ('338545', '1', '陈') ,
 ('339746', '1', '周') ,
 ('339747', '1', '周') ,
 ('339907', '1', '黄') ,
 ('339908', '1', '罗') ,
 ('339909', '1', '胡') ,
 ('339910', '1', '刘') ,
 ('339911', '1', '胡') ,
 ('339912', '1', '邓') ,
 ('339913', '1', '蔡') ,
 ('339914', '1', '肖') ,
 ('339915', '1', '张') ,
 ('339916', '1', '黄') ,
 ('339917', '1', '黄') ,
 ('339918', '1', '朱') ,
 ('339919', '1', '王') ,
 ('339920', '1', '胡') ,
 ('339921', '1', '邝') ,
 ('339922', '1', '张') ,
 ('339923', '1', '陈') ,
 ('339924', '1', '吴') ,
 ('339925', '1', '蔡') ,
 ('339926', '1', '谢') ,
 ('339927', '1', '谢') ,
 ('339928', '1', '张') ,
 ('339929', '1', '张') ,
 ('339930', '1', '谢') ,
 ('339931', '1', '何') ,
 ('339932', '1', '朱') ,
 ('339933', '1', '曾') ,
 ('339934', '1', '肖') ,
 ('339935', '1', '左') ,
 ('339936', '1', '廖') ,
 ('339937', '1', '陈') ,
 ('339938', '1', '王') ,
 ('339939', '1', '杨') ,
 ('339940', '1', '杨') ,
 ('339941', '1', '温') ,
 ('339942', '1', '田') ,
 ('339943', '1', '邱') ,
 ('342740', '1', '谢') ,
 ('343024', '1', '龚') ,
 ('343029', '1', '马') ,
 ('343030', '1', '杨') ,
 ('343031', '1', '邱') ,
 ('343032', '1', '张') ,
 ('343033', '1', '张') ,
 ('343034', '1', '赖') ,
 ('343045', '1', '易') ,
 ('343046', '1', '古') ,
 ('343047', '1', '杨') ,
 ('343048', '1', '洪') ,
 ('343049', '1', '叶') ,
 ('343050', '1', '赖') ,
 ('343051', '1', '刘') ,
 ('343052', '1', '周') ,
 ('343053', '1', '胡') ,
 ('343054', '1', '胡') ,
 ('343055', '1', '胡') ,
 ('343056', '1', '罗') ,
 ('344246', '1', '曾') ,
 ('344247', '1', '刘') ,
 ('344248', '1', '刘') ,
 ('344249', '1', '廖') ,
 ('344250', '1', '刘') ,
 ('344253', '1', '贺') ,
 ('344254', '1', '朱') ,
 ('344255', '1', '杜') ,
 ('344258', '1', '刘') ,
 ('344259', '1', '曾') ,
 ('344260', '1', '曾') ,
 ('344306', '1', '罗') ,
 ('344307', '1', '万') ,
 ('344310', '1', '刘') ,
 ('344311', '1', '刘') ,
 ('344312', '1', '杨') ,
 ('344313', '1', '杨') ,
 ('344314', '1', '喻') ,
 ('344315', '1', '吴') ,
 ('344316', '1', '缪') ,
 ('344317', '1', '杨') ,
 ('344318', '1', '刘') ,
 ('344319', '1', '郭') ,
 ('344320', '1', '郭') ,
 ('344321', '1', '谭') ,
 ('344322', '1', '赖') ,
 ('344323', '1', '黄') ,
 ('344506', '1', '陈') ,
 ('344507', '1', '肖') ,
 ('344508', '1', '谢') ,
 ('344509', '1', '沈') ,
 ('344510', '1', '罗') ,
 ('344511', '1', '罗') ,
 ('344512', '1', '颜') ,
 ('344513', '1', '罗') ,
 ('344514', '1', '罗') ,
 ('344515', '1', '黄') ,
 ('344516', '1', '张') ,
 ('344517', '1', '符') ,
 ('344518', '1', '郭') ,
 ('344519', '1', '陈') ,
 ('344520', '1', '王') ,
 ('344521', '1', '谢') ,
 ('344522', '1', '谢') ,
 ('344523', '1', '谢') ,
 ('344524', '1', '刘') ,
 ('344527', '1', '吴') ,
 ('344528', '1', '李') ,
 ('344529', '1', '李') ,
 ('344530', '1', '杨') ,
 ('344531', '1', '江') ,
 ('344532', '1', '张') ,
 ('344533', '1', '龙') ,
 ('344788', '1', '李') ,
 ('344789', '1', '罗') ,
 ('344790', '1', '符') ,
 ('344791', '1', '李') ,
 ('344792', '1', '徐') ,
 ('344793', '1', '肖') ,
 ('344794', '1', '钟') ,
 ('344795', '1', '吴') ,
 ('344796', '1', '曾') ,
 ('344797', '1', '石') ,
 ('344798', '1', '郭') ,
 ('344799', '1', '谢') ,
 ('344800', '1', '刘') ,
 ('344801', '1', '李') ,
 ('344802', '1', '蓝') ,
 ('344803', '1', '谢') ,
 ('344804', '1', '曾') ,
 ('344805', '1', '杨') ,
 ('344806', '1', '谢') ,
 ('344807', '1', '张') ,
 ('344808', '1', '梁') ,
 ('344809', '1', '王') ,
 ('344810', '1', '张') ,
 ('344811', '1', '张') ,
 ('344812', '1', '魏') ,
 ('344813', '1', '林') ,
 ('344814', '1', '凌') ,
 ('344815', '1', '杨') ,
 ('344816', '1', '杨') ,
 ('344817', '1', '蓝') ,
 ('344818', '1', '钟') ,
 ('344819', '1', '江') ,
 ('344820', '1', '张') ,
 ('344821', '1', '戴') ,
 ('344833', '1', '刘') ,
 ('345089', '1', '刘') ,
 ('345091', '1', '刘') ,
 ('349248', '1', '朱') ,
 ('349279', '1', '阳') ,
 ('349942', '1', '陈') ,
 ('349943', '1', '刘') ,
 ('349944', '1', '郭') ,
 ('349945', '1', '陈') ,
 ('349946', '1', '肖') ,
 ('349947', '1', '刘') ,
 ('352061', '1', '邓') ,
 ('352062', '1', '谢') ,
 ('352063', '1', '蒙') ,
 ('352064', '1', '郭') ,
 ('352065', '1', '邓') ,
 ('352066', '1', '陈') ,
 ('352067', '1', '谢') ,
 ('352068', '1', '蒙') ,
 ('352069', '1', '黎') ,
 ('352070', '1', '晏') ,
 ('352072', '1', '徐') ,
 ('352073', '1', '邱') ,
 ('352074', '1', '黄') ,
 ('352075', '1', '黄') ,
 ('352076', '1', '李') ,
 ('352077', '1', '李') ,
 ('352085', '1', '黄') ,
 ('352092', '1', '李') ,
 ('352093', '1', '张') ,
 ('352094', '1', '李') ,
 ('352095', '1', '乐') ,
 ('352096', '1', '廖') ,
 ('352097', '1', '廖') ,
 ('352098', '1', '张') ,
 ('352099', '1', '廖') ,
 ('352100', '1', '廖') ,
 ('352101', '1', '刘') ,
 ('352102', '1', '陈') ,
 ('352103', '1', '陈') ,
 ('352104', '1', '陈') ,
 ('352105', '1', '刘') ,
 ('352106', '1', '郭') ,
 ('352107', '1', '饶') ,
 ('352108', '1', '李') ,
 ('352109', '1', '张') ,
 ('352318', '1', '李') ,
 ('352353', '1', '杨') ,
 ('352580', '1', '王') ,
 ('352581', '1', '王') ,
 ('353068', '1', '周') ,
 ('353574', '1', '贺') ,
 ('353575', '1', '贺') ,
 ('353576', '1', '胡') ,
 ('353577', '1', '钟') ,
 ('353578', '1', '张') ,
 ('353579', '1', '张') ,
 ('353580', '1', '徐') ,
 ('353581', '1', '朱') ,
 ('353582', '1', '王') ,
 ('353583', '1', '朱') ,
 ('355176', '1', '郑') ,
 ('355177', '1', '李') ,
 ('355178', '1', '朱') ,
 ('355180', '1', '陈') ,
 ('355290', '1', '刘') ,
 ('355294', '1', '刘') ,
 ('358612', '1', '胡') ,
 ('359432', '1', '张') ,
 ('359518', '1', '李') ,
 ('360823', '1', '周') ,
 ('362814', '1', '刘') ,
 ('362815', '1', '谢') ,
 ('362816', '1', '王') ,
 ('362817', '1', '宋') ,
 ('362818', '1', '谢') ,
 ('362819', '1', '胡') ,
 ('362820', '1', '余') ,
 ('362821', '1', '袁') ,
 ('362822', '1', '王') ,
 ('362823', '1', '易') ,
 ('362824', '1', '曾') ,
 ('362825', '1', '胡') ,
 ('362826', '1', '蔡') ,
 ('362827', '1', '杨') ,
 ('362828', '1', '彭') ,
 ('362829', '1', '余') ,
 ('362831', '1', '伍') ,
 ('362832', '1', '伍') ,
 ('362833', '1', '吴') ,
 ('362842', '1', '刘') ,
 ('362843', '1', '陈') ,
 ('362844', '1', '陈') ,
 ('362845', '1', '熊') ,
 ('362846', '1', '丁') ,
 ('362848', '1', '刘') ,
 ('362849', '1', '钟') ,
 ('362850', '1', '秦') ,
 ('362851', '1', '杨') ,
 ('362852', '1', '刘') ,
 ('362865', '1', '廖') ,
 ('362866', '1', '曾')

mingqing6364 2016-08-22

打赏
举报

向T1插入数据：


INSERT INTO [test].[dbo].[T1] ([HH], [CFWZ]) VALUES ('1', '1-1-1-1');

向T2插入数据：


INSERT INTO [test].[dbo].[T2] ([ID], [SLBH], [HH]) VALUES
 ('93617', '2016', '1') ,
 ('333829', '2016', '1') ,
 ('333835', '2016', '1') ,
 ('333845', '2016', '1') ,
 ('334083', '2016', '1') ,
 ('334094', '2016', '1') ,
 ('334098', '2016', '1') ,
 ('335036', '2016', '1') ,
 ('335040', '2016', '1') ,
 ('335043', '2016', '1') ,
 ('336002', '2016', '1') ,
 ('336536', '2016', '1') ,
 ('336537', '2016', '1') ,
 ('336538', '2016', '1') ,
 ('336539', '2016', '1') ,
 ('338538', '2016', '1') ,
 ('338539', '2016', '1') ,
 ('338540', '2016', '1') ,
 ('338541', '2016', '1') ,
 ('338542', '2016', '1') ,
 ('338543', '2016', '1') ,
 ('338544', '2016', '1') ,
 ('338545', '2016', '1') ,
 ('339746', '2016', '1') ,
 ('339747', '2016', '1') ,
 ('339907', '2016', '1') ,
 ('339908', '2016', '1') ,
 ('339909', '2016', '1') ,
 ('339910', '2016', '1') ,
 ('339911', '2016', '1') ,
 ('339912', '2016', '1') ,
 ('339913', '2016', '1') ,
 ('339914', '2016', '1') ,
 ('339915', '2016', '1') ,
 ('339916', '2016', '1') ,
 ('339917', '2016', '1') ,
 ('339918', '2016', '1') ,
 ('339919', '2016', '1') ,
 ('339920', '2016', '1') ,
 ('339921', '2016', '1') ,
 ('339922', '2016', '1') ,
 ('339923', '2016', '1') ,
 ('339924', '2016', '1') ,
 ('339925', '2016', '1') ,
 ('339926', '2016', '1') ,
 ('339927', '2016', '1') ,
 ('339928', '2016', '1') ,
 ('339929', '2016', '1') ,
 ('339930', '2016', '1') ,
 ('339931', '2016', '1') ,
 ('339932', '2016', '1') ,
 ('339933', '2016', '1') ,
 ('339934', '2016', '1') ,
 ('339935', '2016', '1') ,
 ('339936', '2016', '1') ,
 ('339937', '2016', '1') ,
 ('339938', '2016', '1') ,
 ('339939', '2016', '1') ,
 ('339940', '2016', '1') ,
 ('339941', '2016', '1') ,
 ('339942', '2016', '1') ,
 ('339943', '2016', '1') ,
 ('342740', '2016', '1') ,
 ('343024', '2016', '1') ,
 ('343029', '2016', '1') ,
 ('343030', '2016', '1') ,
 ('343031', '2016', '1') ,
 ('343032', '2016', '1') ,
 ('343033', '2016', '1') ,
 ('343034', '2016', '1') ,
 ('343045', '2016', '1') ,
 ('343046', '2016', '1') ,
 ('343047', '2016', '1') ,
 ('343048', '2016', '1') ,
 ('343049', '2016', '1') ,
 ('343050', '2016', '1') ,
 ('343051', '2016', '1') ,
 ('343052', '2016', '1') ,
 ('343053', '2016', '1') ,
 ('343054', '2016', '1') ,
 ('343055', '2016', '1') ,
 ('343056', '2016', '1') ,
 ('344246', '2016', '1') ,
 ('344247', '2016', '1') ,
 ('344248', '2016', '1') ,
 ('344249', '2016', '1') ,
 ('344250', '2016', '1') ,
 ('344253', '2016', '1') ,
 ('344254', '2016', '1') ,
 ('344255', '2016', '1') ,
 ('344258', '2016', '1') ,
 ('344259', '2016', '1') ,
 ('344260', '2016', '1') ,
 ('344306', '2016', '1') ,
 ('344307', '2016', '1') ,
 ('344310', '2016', '1') ,
 ('344311', '2016', '1') ,
 ('344312', '2016', '1') ,
 ('344313', '2016', '1') ,
 ('344314', '2016', '1') ,
 ('344315', '2016', '1') ,
 ('344316', '2016', '1') ,
 ('344317', '2016', '1') ,
 ('344318', '2016', '1') ,
 ('344319', '2016', '1') ,
 ('344320', '2016', '1') ,
 ('344321', '2016', '1') ,
 ('344322', '2016', '1') ,
 ('344323', '2016', '1') ,
 ('344506', '2016', '1') ,
 ('344507', '2016', '1') ,
 ('344508', '2016', '1') ,
 ('344509', '2016', '1') ,
 ('344510', '2016', '1') ,
 ('344511', '2016', '1') ,
 ('344512', '2016', '1') ,
 ('344513', '2016', '1') ,
 ('344514', '2016', '1') ,
 ('344515', '2016', '1') ,
 ('344516', '2016', '1') ,
 ('344517', '2016', '1') ,
 ('344518', '2016', '1') ,
 ('344519', '2016', '1') ,
 ('344520', '2016', '1') ,
 ('344521', '2016', '1') ,
 ('344522', '2016', '1') ,
 ('344523', '2016', '1') ,
 ('344524', '2016', '1') ,
 ('344527', '2016', '1') ,
 ('344528', '2016', '1') ,
 ('344529', '2016', '1') ,
 ('344530', '2016', '1') ,
 ('344531', '2016', '1') ,
 ('344532', '2016', '1') ,
 ('344533', '2016', '1') ,
 ('344788', '2016', '1') ,
 ('344789', '2016', '1') ,
 ('344790', '2016', '1') ,
 ('344791', '2016', '1') ,
 ('344792', '2016', '1') ,
 ('344793', '2016', '1') ,
 ('344794', '2016', '1') ,
 ('344795', '2016', '1') ,
 ('344796', '2016', '1') ,
 ('344797', '2016', '1') ,
 ('344798', '2016', '1') ,
 ('344799', '2016', '1') ,
 ('344800', '2016', '1') ,
 ('344801', '2016', '1') ,
 ('344802', '2016', '1') ,
 ('344803', '2016', '1') ,
 ('344804', '2016', '1') ,
 ('344805', '2016', '1') ,
 ('344806', '2016', '1') ,
 ('344807', '2016', '1') ,
 ('344808', '2016', '1') ,
 ('344809', '2016', '1') ,
 ('344810', '2016', '1') ,
 ('344811', '2016', '1') ,
 ('344812', '2016', '1') ,
 ('344813', '2016', '1') ,
 ('344814', '2016', '1') ,
 ('344815', '2016', '1') ,
 ('344816', '2016', '1') ,
 ('344817', '2016', '1') ,
 ('344818', '2016', '1') ,
 ('344819', '2016', '1') ,
 ('344820', '2016', '1') ,
 ('344821', '2016', '1') ,
 ('344833', '2016', '1') ,
 ('345089', '2016', '1') ,
 ('345091', '2016', '1') ,
 ('349248', '2016', '1') ,
 ('349279', '2016', '1') ,
 ('349942', '2016', '1') ,
 ('349943', '2016', '1') ,
 ('349944', '2016', '1') ,
 ('349945', '2016', '1') ,
 ('349946', '2016', '1') ,
 ('349947', '2016', '1') ,
 ('352061', '2016', '1') ,
 ('352062', '2016', '1') ,
 ('352063', '2016', '1') ,
 ('352064', '2016', '1') ,
 ('352065', '2016', '1') ,
 ('352066', '2016', '1') ,
 ('352067', '2016', '1') ,
 ('352068', '2016', '1') ,
 ('352069', '2016', '1') ,
 ('352070', '2016', '1') ,
 ('352072', '2016', '1') ,
 ('352073', '2016', '1') ,
 ('352074', '2016', '1') ,
 ('352075', '2016', '1') ,
 ('352076', '2016', '1') ,
 ('352077', '2016', '1') ,
 ('352085', '2016', '1') ,
 ('352092', '2016', '1') ,
 ('352093', '2016', '1') ,
 ('352094', '2016', '1') ,
 ('352095', '2016', '1') ,
 ('352096', '2016', '1') ,
 ('352097', '2016', '1') ,
 ('352098', '2016', '1') ,
 ('352099', '2016', '1') ,
 ('352100', '2016', '1') ,
 ('352101', '2016', '1') ,
 ('352102', '2016', '1') ,
 ('352103', '2016', '1') ,
 ('352104', '2016', '1') ,
 ('352105', '2016', '1') ,
 ('352106', '2016', '1') ,
 ('352107', '2016', '1') ,
 ('352108', '2016', '1') ,
 ('352109', '2016', '1') ,
 ('352318', '2016', '1') ,
 ('352353', '2016', '1') ,
 ('352580', '2016', '1') ,
 ('352581', '2016', '1') ,
 ('353068', '2016', '1') ,
 ('353574', '2016', '1') ,
 ('353575', '2016', '1') ,
 ('353576', '2016', '1') ,
 ('353577', '2016', '1') ,
 ('353578', '2016', '1') ,
 ('353579', '2016', '1') ,
 ('353580', '2016', '1') ,
 ('353581', '2016', '1') ,
 ('353582', '2016', '1') ,
 ('353583', '2016', '1') ,
 ('355176', '2016', '1') ,
 ('355177', '2016', '1') ,
 ('355178', '2016', '1') ,
 ('355180', '2016', '1') ,
 ('355290', '2016', '1') ,
 ('355294', '2016', '1') ,
 ('358612', '2016', '1') ,
 ('359432', '2016', '1') ,
 ('359518', '2016', '1') ,
 ('360823', '2016', '1') ,
 ('362814', '2016', '1') ,
 ('362815', '2016', '1') ,
 ('362816', '2016', '1') ,
 ('362817', '2016', '1') ,
 ('362818', '2016', '1') ,
 ('362819', '2016', '1') ,
 ('362820', '2016', '1') ,
 ('362821', '2016', '1') ,
 ('362822', '2016', '1') ,
 ('362823', '2016', '1') ,
 ('362824', '2016', '1') ,
 ('362825', '2016', '1') ,
 ('362826', '2016', '1') ,
 ('362827', '2016', '1') ,
 ('362828', '2016', '1') ,
 ('362829', '2016', '1') ,
 ('362831', '2016', '1') ,
 ('362832', '2016', '1') ,
 ('362833', '2016', '1') ,
 ('362842', '2016', '1') ,
 ('362843', '2016', '1') ,
 ('362844', '2016', '1') ,
 ('362845', '2016', '1') ,
 ('362846', '2016', '1') ,
 ('362848', '2016', '1') ,
 ('362849', '2016', '1') ,
 ('362850', '2016', '1') ,
 ('362851', '2016', '1') ,
 ('362852', '2016', '1') ,
 ('362865', '2016', '1') ,
 ('362866', '2016', '1')