Re: Cross tab with non-numeric information

NancyASAP wrote:
> 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

Then go to Morgan's Library at www.psoug.org and look up DECODE.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)