1
/*
2
将表数据旋转90度(2007-11-19于海南三亚)
3![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
4
将下表数据:
5
A b c d e
6
-------------------- ----------- ----------- ----------- -----------
7
x 1 2 3 4
8
y 5 6 7 8
9
z 9 10 11 12
10![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
转化成如下结果:
12
a x y z
13
-------------------- ---------- ---------- ----------
14
b 1 5 9
15
c 2 6 10
16
d 3 7 11
17
e 4 8 12
18![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
19
*/
20![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
--生成测试数据
22
create table test1(A varchar(20),b int,c int,d int,e int)
23
insert into test1 select 'x',1,2 ,3 ,4
24
insert into test1 select 'y',5,6 ,7 ,8
25
insert into test1 select 'z',9,10,11,12
26
go
27![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
--生成中间数据表
29
declare @s varchar(8000)
30
set @s = 'create table test2(a varchar(20)'
31
select @s = @s + ',' + A + ' varchar(10)' from test1
32
set @s = @s + ')'
33
exec(@s)
34
print @s
35
--借助中间表实现行列转换
36
declare @name varchar(20)
37![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
declare t_cursor cursor for
39
select name from syscolumns
40
where id=object_id('test1') and colid > 1 order by colid
41![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
42
open t_cursor
43![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
44
fetch next from t_cursor into @name
45![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
46
while @@fetch_status = 0
47
begin
48
exec('select ' + @name + ' as t into test3 from test1')
49
set @s='insert into test2 select ''' + @name + ''''
50
select @s = @s + ',''' + rtrim(t) + '''' from test3
51
exec(@s)
52
exec('drop table test3')
53
fetch next from t_cursor into @name
54
end
55
close t_cursor
56
deallocate t_cursor
57![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
58
--查看行列互换处理结果
59
select * from test1
60
select * from test2
61![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
62
--删除表
63
drop table test1
64
drop table test2
65
----------------------------------------------------------------------------
66
/*固定的写法:*/
67
select t1.* , t2.y , t3.z from
68
(select a = 'b' , x = b from test1 where a = 'x') t1,
69
(select a = 'b' , y = b from test1 where a = 'y') t2,
70
(select a = 'b' , z = b from test1 where a = 'z') t3
71
where t1.a = t2.a and t1.a = t2.a
72
union all
73
select t1.* , t2.y , t3.z from
74
(select a = 'c' , x = c from test1 where a = 'x') t1,
75
(select a = 'c' , y = c from test1 where a = 'y') t2,
76
(select a = 'c' , z = c from test1 where a = 'z') t3
77
where t1.a = t2.a and t1.a = t2.a
78
union all
79
select t1.* , t2.y , t3.z from
80
(select a = 'd' , x = d from test1 where a = 'x') t1,
81
(select a = 'd' , y = d from test1 where a = 'y') t2,
82
(select a = 'd' , z = d from test1 where a = 'z') t3
83
where t1.a = t2.a and t1.a = t2.a
84
union all
85
select t1.* , t2.y , t3.z from
86
(select a = 'e' , x = e from test1 where a = 'x') t1,
87
(select a = 'e' , y = e from test1 where a = 'y') t2,
88
(select a = 'e' , z = e from test1 where a = 'z') t3
89
where t1.a = t2.a and t1.a = t2.a
90![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
91
----------------------------------------------------------------------------
92
/*
93
表tb,数据如下:
94
项目种类 业绩 提成
95
洗吹类 200 10
96
外卖 100 5
97
合计 300 15
98
转换成:
99
项目种类 洗吹类 外卖 合计
100
业绩 200 100 300
101
提成 10 5 15
102
*/
103![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
104
create table tb
105
(
106
项目种类 varchar(10),
107
业绩 int,
108
提成 int
109
)
110![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
111
insert into tb(项目种类,业绩,提成) values('洗吹类',200,10)
112
insert into tb(项目种类,业绩,提成) values('外卖' ,100,5)
113
insert into tb(项目种类,业绩,提成) values('合计' ,300,15)
114
go
115![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
116
select 项目种类,sum(洗吹类) as 洗吹类 , sum(外卖) as 外卖 , sum(合计) as 合计 from
117
(
118
select 项目种类 = '业绩',
119
洗吹类 = case when 项目种类 = '洗吹类' then 业绩 else 0 end,
120
外卖 = case when 项目种类 = '外卖' then 业绩 else 0 end,
121
合计 = case when 项目种类 = '合计' then 业绩 else 0 end
122
from tb
123
union all
124
select 项目种类 = '提成' ,
125
洗吹类 = case when 项目种类 = '洗吹类' then 提成 else 0 end,
126
外卖 = case when 项目种类 = '外卖' then 提成 else 0 end,
127
合计 = case when 项目种类 = '合计' then 提成 else 0 end
128
from tb
129
) m
130
group by 项目种类
131
order by 项目种类 desc
132![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
133
drop table tb
134![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
135
/*
136
项目种类 洗吹类 外卖 合计
137
-------- ----------- ----------- -----------
138
业绩 200 100 300
139
提成 10 5 15
140![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
141
(所影响的行数为 2 行)
142
*/
143![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
144
--------------------------------------------------------------------------
145
/*
146
数据库中tb表格如下
147
148
月份 工资 福利 奖金
149
1月 100 200 300
150
2月 110 210 310
151
3月 120 220 320
152
4月 130 230 330
153![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
154
我想得到的结果是
155![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
156
项目 1月 2月 3月 4月
157
工资 100 110 120 130
158
福利 200 210 220 230
159
奖金 300 310 320 330
160![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
161
就是说完全把表格的行列颠倒,有点像那种旋转矩阵,请问如何用sql 语句实现?
162
*/
163![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
164
if exists (select * from dbo.sysobjects
165
where id = object_id(N'[dbo].[p_zj]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
166
drop procedure [dbo].[p_zj]
167
GO
168
/*--行列互换的通用存储过程(原著:邹建):将指定的表,按指定的字段进行行列互换*/
169![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
170
create proc p_zj
171
@tbname sysname, --要处理的表名
172
@fdname sysname, --做为转换的列名
173
@new_fdname sysname='' --为转换后的列指定列名
174
as
175
declare @s1 varchar(8000) , @s2 varchar(8000),
176
@s3 varchar(8000) , @s4 varchar(8000),
177
@s5 varchar(8000) , @i varchar(10)
178
select @s1 = '' , @s2 = '' , @s3 = '' , @s4 = '' , @s5 = '' , @i = '0'
179
select @s1 = @s1 + ',@' + @i + ' varchar(8000)',
180
@s2 = @s2 + ',@' + @i + '=''' + case isnull(@new_fdname , '') when '' then ''
181
else @new_fdname + '=' end + '''''' + name + '''''''',
182
@s3 = @s3 + 'select @' + @i + '=@' + @i + '+'',['' + [' + @fdname +
183
']+'']=''+cast([' + name + '] as varchar) from [' + @tbname + ']',
184
@s4 = @s4 + ',@' + @i + '=''select ''+@' + @i,
185
@s5 = @s5 + '+'' union all ''+@' + @i,
186
@i=cast(@i as int)+1
187
from syscolumns
188
where object_id(@tbname)=id and name<>@fdname
189![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
190
select @s1=substring(@s1,2,8000),
191
@s2=substring(@s2,2,8000),
192
@s4=substring(@s4,2,8000),
193
@s5=substring(@s5,16,8000)
194
exec('declare ' + @s1 + 'select ' + @s2 + @s3 + 'select ' + @s4 + '
195
exec(' + @s5 + ')')
196
go
197![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
198
--用上面的存储过程测试:
199![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
200
create table Test(月份 varchar(4), 工资 int, 福利 int, 奖金 int)
201
insert Test
202
select '1月',100,200,300 union all
203
select '2月',110,210,310 union all
204
select '3月',120,220,320 union all
205
select '4月',130,230,330
206
go
207![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
208
exec p_zj 'Test', '月份' , '项目'
209![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
210
drop table Test
211
drop proc p_zj
212![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
213
/*
214
项目 1月 2月 3月 4月
215
---- ----------- ----------- ----------- -----------
216
福利 200 210 220 230
217
工资 100 110 120 130
218
奖金 300 310 320 330
219![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
220
(所影响的行数为 3 行)
221
*/
222![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
223
/*
224
静态写法(SQL2005)
225
*/
226
--测试环境
227
create table Test(月份 varchar(4), 工资 int, 福利 int, 奖金 int)
228
insert Test
229
select '1月',100,200,300 union all
230
select '2月',110,210,310 union all
231
select '3月',120,220,320 union all
232
select '4月',130,230,330
233
go
234
--测试语句
235
SELECT * FROM
236
(
237
SELECT 考核月份,月份,金额 FROM
238
(SELECT 月份, 工资, 福利, 奖金 FROM Test) p
239
UNPIVOT
240
(金额 FOR 考核月份 IN (工资, 福利, 奖金))AS unpvt
241
) T
242
PIVOT
243
(MAX(金额) FOR 月份 in ([1月],[2月],[3月],[4月]))AS pt
244![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
245
--测试结果
246![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
247
/*
248
考核月份 1月 2月 3月 4月
249
------- ----- ----- ------ -------
250
福利200210220230
251
工资100110120130
252
奖金300310320330
253
*/
254![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
255
--删除环境
256
Drop table Test
257![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
38
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
39
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
40
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
41
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
42
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
43
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
44
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
45
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
46
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
47
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
48
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
49
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
50
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
51
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
52
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
53
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
54
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
55
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
56
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
57
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
58
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
59
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
60
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
61
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
62
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
63
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
64
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
65
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
66
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
67
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
68
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
69
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
70
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
71
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
72
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
73
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
74
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
75
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
76
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
77
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
78
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
79
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
80
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
81
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
82
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
83
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
84
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
85
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
86
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
87
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
88
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
89
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
90
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
91
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
92
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
93
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
94
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
95
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
96
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
97
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
98
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
99
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
100
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
101
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
102
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
103
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
104
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
105
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
106
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
107
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
108
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
109
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
110
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
111
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
112
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
113
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
114
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
115
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
116
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
117
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
118
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
119
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
120
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
121
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
122
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
123
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
124
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
125
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
126
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
127
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
128
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
129
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
130
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
131
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
132
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
133
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
134
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
135
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
136
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
137
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
138
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
139
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
140
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
141
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
142
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
143
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
144
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
145
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
146
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
147
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
148
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
149
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
150
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
151
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
152
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
153
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
154
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
155
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
156
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
157
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
158
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
159
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
160
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
161
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
162
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
163
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
164
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
165
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
166
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
167
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
168
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
169
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
170
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
171
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
172
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
173
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
174
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
175
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
176
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
177
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
178
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
179
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
180
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
181
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
182
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
183
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
184
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
185
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
186
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
187
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
188
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
189
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
190
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
191
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
192
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
193
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
194
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
195
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
196
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
197
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
198
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
199
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
200
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
201
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
202
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
203
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
204
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
205
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
206
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
207
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
208
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
209
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
210
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
211
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
212
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
213
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
214
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
215
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
216
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
217
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
218
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
219
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
220
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
221
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
222
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
223
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
224
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
225
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
226
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
227
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
228
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
229
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
230
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
231
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
232
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
233
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
234
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
235
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
236
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
237
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
238
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
239
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
240
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
241
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
242
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
243
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
244
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
245
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
246
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
247
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
248
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
249
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
250
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
251
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
252
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
253
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
254
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
255
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
256
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
257
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)