A B C
Id
Qing bamboo 0707 1
2 color scale 0410 2
3 Lin 0102 1
3 0102 Lin 2
3 Lin 0102 3
merged results similar to the
A B C
Id
Qing bamboo 0707 1
2 color scale 0410 2
3 Lin 0102 1, 2, 3
online a lot of methods, similar to the FOR XML PATH (' '), after trying to query can be successful, but I amount of data in the database is large, more than 10000 data checked FOR 2 minutes,, is there a better way to provide
