如表t1:
a a
----------------------------
1 a
2 b
3 c
4 d
换成:new_t1:
1 2 3 4
-----------------------------
a b c d
推荐你篇文章:看看可能会有收获
http://www.chinahtml.com/0702/mssql117046784310795.html