求助!!up有分
cate values dates
A1 12.32,15.6,14.5,45.00,78.12,23.45 2006-04-01
A2 14.56,67.23,45.12,23.1,34.67,56.98 2006-04-01
A1 12.31,15.6,14.5,44.00,78.12,23.45 2006-04-01
A2 14.56,67.23,45.12,23.1,34.67,56.98 2006-04-01
A1 12.32,15.6,14.5,45.00,78.12,23.45 2006-05-01
A2 14.56,67.23,45.12,23.1,34.67,56.98 2006-05-01
A1 12.31,15.6,14.5,44.00,78.12,23.45 2006-05-01
A2 14.56,67.23,45.12,23.1,34.67,56.98 2006-05-01
不用存储过程实现如下数据统计
cate T1 dates
A1 24.63,31.2,29.0,89.0,156.24,46.9 2006-04-01
A1 24.63,31.2,29.0,89.0,156.24,46.9 2006-05-01
A2 29.12,134.46,90.24,46.2,69.34,113.96 2006-04-01
A2 29.12,134.46,90.24,46.2,69.34,113.96 2006-05-01
==========================================================================
就是 values 值之间用,隔开的,当cate和dates 相同时 算values中各个以,隔开的数值的累加,要求是不用存储过程实现
[解决办法]
当cate和dates 相同时,算values中各个以,隔开的数值的累加 ??????????
[解决办法]
http://community.csdn.net/Expert/topic/5669/5669504.xml?temp=.4309198
=====================================================================寒自己一下``
------解决方案--------------------
那个不对的.没汇总
[解决办法]
。。。。。。。。。。。。。
[解决办法]
只能先拆了求和之後再合起來。。。。
[解决办法]
下边只是求其中前2个数的,实在写不下去了，表设计的不合理.
===========================================================================
declare @t table(cate varchar(10),[values] varchar(40),dates varchar(10))
insert into @t select 'A1 ', '12.32,15.6,14.5,45.00,78.12,23.45 ', '2006-04-01 '
insert into @t select 'A2 ', '14.56,67.23,45.12,23.1,34.67,56.98 ', '2006-04-01 '
insert into @t select 'A1 ', '12.31,15.6,14.5,44.00,78.12,23.45 ', '2006-04-01 '
insert into @t select 'A2 ', '14.56,67.23,45.12,23.1,34.67,56.98 ', '2006-04-01 '
insert into @t select 'A1 ', '12.32,15.6,14.5,45.00,78.12,23.45 ', '2006-05-01 '
insert into @t select 'A2 ', '14.56,67.23,45.12,23.1,34.67,56.98 ', '2006-05-01 '
insert into @t select 'A1 ', '12.31,15.6,14.5,44.00,78.12,23.45 ', '2006-05-01 '
insert into @t select 'A2 ', '14.56,67.23,45.12,23.1,34.67,56.98 ', '2006-05-01 '
select cate,convert(varchar(8),sum(convert(numeric(4,2),substring([values],1,charindex( ', ',[values])-1))))+ ', '+
convert(varchar(8),sum(convert(numeric(4,2),substring([values],charindex( ', ',[values])+1,charindex( ', ',[values],charindex( ', ',[values])-1)-2))))
,dates
from @t
group by cate,dates
[解决办法]
JF
[解决办法]
http://community.csdn.net/Expert/topic/5669/5669504.xml?temp=.8959925
