Average Across Columns per Row

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

dmc-608719 SSCarpal Tunnel Points: 4663 More actions · Answer 1

Not sure how elegant of a solution you are looking for....

But if you have the values already, just use simple math.

SELECT rating1, rating2, ((rating1 + rating2)/2) as [total]

FROM sometable.

If you are looking for something a little more dynamic, I would look at pivoting the columns into rows by user and then use the avg() function.