SQL Server Group By Bitwise Or?

Question

Possible Duplicates:
Aggregate bitwise-OR in a subquery
Update column to be different aggregate values

Let's say I have a table with the following records.

Role | AuthorizationNum

1      11
2      12
1      16
2      11

What I want to do is group by Role, the OR (BIT OR using |) AuthorizationNum. So my select should be 2 records.

Role | AuthorizationNum

1      27
2      15

Because...

11 | 16 = 27

11 | 12 = 15

do u need the sum of the authorizationNum grouped by roleID? — reggie, Feb 16 '11 at 16:42
You want to use bitwise or as an aggregate function? If so this is a dupe... Just trying to find it. — Martin Smith, Feb 16 '11 at 16:45
@Martin here is the duplicate - http://stackoverflow.com/questions/1112382/update-column-to-be-different-aggregate-values — JonH, Feb 16 '11 at 16:49

score 0 · Answer 1 · edited May 23 '17 at 12:10

0

By default mysql supports this but not sql server. But you can get around it using this: Update column to be different aggregate values

edited May 23 '17 at 12:10

Community

answered Feb 16 '11 at 16:48

JonH

Now I understand what he meant. Sorry for the confustion – reggie Feb 16 '11 at 16:50

1 Answers1