求一过程

Question

select sum(datediff(day,starttime,endtime)/money) from table

Answer 1

select sum([Money]*1.0/datediff(day,StartTime,EndTime))
from table1

Answer 2

晕
create table test
(id int,
money money,
starttime datetime,
endtime datetime)
insert test(id,money,starttime,endtime)
select 2,10,'2006-1-1','2006-1-11' union all
select 5,50,'2006-5-8','2006-5-28' select sum(money/datediff(d,starttime,endtime)) as 总金额
from testselect * from testdrop table test