declare @cy datetime
set @d = '12/01/2010'
select SUM(total) from (
select sum(amt1) as total from table1
where date1 < @d
select sum(amt1) as total from table1
where date1 >= @d
) as a
thank in advance!
sql server aggregate float values
Hi Everyone!
Ask by Anonymous User
Updated 08 May 2013
Can you answer this question?
Write Answer1 Answers