一个行列转换的问题

Question

本帖最后由 wang520d 于 2012-07-09 11:50:04 编辑

Answer 1

Nodeid      MyText
----------- ----------------------------------------------------------------------------------------------------
17          网络
18          论坛
19          百度
20          博客
21          平媒
22          北晚
23          京华
24          新华
25          短信自发
26          市场活动
27          总部支持
28          集团
29          外包
30          校区问卷
31          宣传册
32          校区推广
33          拉上
34          客户信息(18 行受影响)校区                                                 客户来源                                               数量          最后联系时间
-------------------------------------------------- -------------------------------------------------- ----------- -------------------
1                                                  18                                                 1           2012-07-09 00:00:00
1                                                  34                                                 171         2012-07-09 00:00:00
11                                                 34                                                 40          2012-07-09 00:00:00
2                                                  34                                                 7           2012-07-09 00:00:00
3                                                  34                                                 29          2012-07-09 00:00:00
4                                                  34                                                 11          2012-07-09 00:00:00
5                                                  34                                                 76          2012-07-09 00:00:00
6                                                  34                                                 11          2012-07-09 00:00:00
7                                                  34                                                 52          2012-07-09 00:00:00
8                                                  34                                                 54          2012-07-09 00:00:00(10 行受影响)校区                                                 拉上          网站
-------------------------------------------------- ----------- -----------
1                                                  1           171
11                                                 0           40
2                                                  0           7
3                                                  0           29
4                                                  0           11
5                                                  0           76
6                                                  0           11
7                                                  0           52
8                                                  0           54
9                                                  0           4(10 行受影响)

Answer 2

Nodeid      MyText
----------- ----------------------------------------------------------------------------------------------------
17          网络
18          论坛
19          百度
20          博客
21          平媒
22          北晚
23          京华
24          新华
25          短信自发
26          市场活动
27          总部支持
28          集团
29          外包
30          校区问卷
31          宣传册
32          校区推广
33          拉上
34          客户信息(18 行受影响)校区                                                 客户来源                                               数量          最后联系时间
-------------------------------------------------- -------------------------------------------------- ----------- -------------------
1                                                  18                                                 1           2012-07-09 00:00:00
1                                                  34                                                 171         2012-07-09 00:00:00
11                                                 34                                                 40          2012-07-09 00:00:00
2                                                  34                                                 7           2012-07-09 00:00:00
3                                                  34                                                 29          2012-07-09 00:00:00
4                                                  34                                                 11          2012-07-09 00:00:00
5                                                  34                                                 76          2012-07-09 00:00:00
6                                                  34                                                 11          2012-07-09 00:00:00
7                                                  34                                                 52          2012-07-09 00:00:00
8                                                  34                                                 54          2012-07-09 00:00:00(10 行受影响)校区                                                 拉上          网站
-------------------------------------------------- ----------- -----------
1                                                  1           171
11                                                 0           40
2                                                  0           7
3                                                  0           29
4                                                  0           11
5                                                  0           76
6                                                  0           11
7                                                  0           52
8                                                  0           54
9                                                  0           4(10 行受影响)