COMBINE RECORDS - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

COMBINE RECORDS

COMBINE RECORDS# Database - 数据库

z*n2010-12-16 08:12

1 楼

http://www.youtube.com/watch?v=TCRNSLLK92c
《阿拉侬》世博会主题曲中文版
作词：Quincy Jones、Siedah Garrett
作曲：谭盾、Quincy Jones
演唱：张靓颖、刘德华
阿拉到上海来看世博，
Ala nong,nong,nong-better city.
希望城市更加美好，
Ala nong,nong,nong-better life.
阿拉从上海来看世界，
Ala nong,nong,nong-better city.
要让生活更加快乐，
Ala nong,nong,nong-better life.
阿拉到上海来看世博，
Ala nong,nong,nong-better city.
希望城市更加美好，
Ala nong,nong,nong-better life.
阿拉从上海来看世界，
Ala nong,nong,nong-better city.
要让生活更加快乐，
Ala nong,nong,nong-better life.
我们每一个梦都会撑著要我们尽心努力有收获
一起做实现更多
一起做力量的横墙
我

g*l2010-12-16 08:12

2 楼

ID VALUE
1 1
1 2
1 3
1 4
2 1
2 2
2 3
3 1
3 2
3 3
3 4
3 5
3 6
3 7
3 8
3 9
3 10
4 1
我想弄成
ID VALUE
1 12345
2 123
3 123456789
4 1
每个ID不知道有多少VALUE，我取到9就结束了
写了个CURSOR，倒腾了半天没搞对

i*a2010-12-16 08:12

3 楼

Google row concatenation

v*r2010-12-16 08:12

4 楼

Here is a good summary of methods to do string aggregation in Oracle. Some
of them (like the one using analytic function) should be applicable to
SQLServer as well.
http://www.oracle-base.com/articles/misc/StringAggregationTechniques.php

【在 g***l 的大作中提到】