Thanks Michel. I had looked at AskTom, but didn't know to look under
"pivot table". (AskTom totally rocks!!!) I found what I needed there.
In case it helps someone else, the SQL I came up with is as follows:
select userpermissionid,
max(decode(usergroupid,1,enabled)) grp1,
max(decode(usergroupid,2,enabled)) grp2,
max(decode(usergroupid,3,enabled)) grp3,
max(decode(usergroupid,4,enabled)) grp4,
max(decode(usergroupid,5,enabled)) grp5,
max(decode(usergroupid,6,enabled)) grp6,
max(decode(usergroupid,7,enabled)) grp7,
max(decode(usergroupid,8,enabled)) grp8,
max(decode(usergroupid,999,enabled)) grp999
from usergrouppermissions
group by userpermissionid
I appreciate the tip.
Nancyasap
Received on Fri Mar 17 2006 - 13:32:54 CST
