Viewing post 1 (of 1 total)
Select id,name,sum(isnull(old,0)),sum(isnull(new,0))
From Test1
Group By id,name
this could also work
February 27, 2012 at 4:25 am
#1451977