shallow streams make most din;still waters run deep- --phenomenal pure princess
2006-04-08 15:49
2006-04-08 17:16
2006-04-09 08:43
这几句看不懂啊，
select @sql = @sql + ',sum(case Subject when '''+Subject+''' then Result end) ['+Subject+']'
是什么作用啊，为什么还要sum
from (select distinct Subject from CJ) as a--这句我倒是可以看懂
select @sql = @sql+' from test group by name'
这句同楼上所说的，不怎么明白，希望赐教了
2006-04-09 08:48
2006-04-11 16:18
2006-04-11 17:22
2006-04-12 08:29
2006-04-14 19:22
2006-04-15 01:39
2006-05-04 15:42