How to get aggregate float values in sql server 2008. I'm try as following
declare @cy datetime
set @d = '12/01/2010'
select SUM(total) from (
select sum(amt1) as total from table1
where date1 < @d
union all
select sum(amt1) as total from table1
where date1 >= @d
) as a
thank in advance!
Can you answer this question?
Write Answer1 Answers