What is the Best way?

[geminihk]

Hi,

I ve a table with the following structure:

Col1 Col2 Col3 Col4
AA 3000 BB 2000
BB 5000 AA 1000
CC 2000 BB 500
AA 1200 CC 300
BB 500 CC 100
AA 1000

I want to get a result as follows:

RC1 RC2
AA 6200
BB 8000
CC 2400

I used cursor still not getting the exact result & not know how to retun a this from the SP.

I would like to use SP to return the result set to he user.

Thanks.

 

[swampBoogie]

select col1,sum(col2)
from 
(select col1,col2 from t
union all
select col3,col4 from t) dt
group by col1

 

[geminihk]

Thank you so much SwamBoogie.