forum

Home / DeveloperSection / Forums / sql server aggregate float values

Ask Question

sql server aggregate float values

Anonymous User189208-May-2013
Hi Everyone!

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! 
mssql servermssql server 
Updated on 08-May-2013
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

AVADHESH PATEL

AVADHESH PATEL

08-May-2013
Hi Ankita!

I suspect you are using UNION because there are actually two different tables in your queries, e.g., table1 and table2. In that case, you should not expect the sum to be the same when the date changes.

Update: I just noticed that you are selecting amt in one query and amt1 in the other, so there is no reason to expect the sums to be the same as the date changes.

Liked By