lvyafei

摘要： 1.declare @sql varchar(8000)set @sql='select name'set @sql=@sql+',sum(case subject when'''+subject+'''then result else 0 end)['+subject']'from (select distinct subject from t_person)as t_personset @sql=@sql+'from t_person group by name'exec(@sq 阅读全文

摘要： 数据库表:t_persons select * from t_personsID name date money1 李天 2012-01-01 00:00:00.000 1002 李忠 2012-02-01 00:00:00.000 2003 李天 2012-01-01 00:00:00.000 1004 李忠 2012-02-02 00:00:00.000 5005 李敏 2011-01-01 00:00:00.000 ... 阅读全文