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.
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.