PIVOT TABLE in SQL

[deltaair]

Hello,

I have a table with 3 columns, where person_id is unique id.
<person_id> <event_type> <number_events>

1. I need to transform this into a table with <person_id> <event_type1> <event_type2>.... <event_type-n>
And under each column I need to fill the number_events for each event_type for that person_id

2. Next step is to use that table and convert the same into % of number_events under each event_type, as % of total number_events for each id_member

Thanks

 

[markros]

I believe if you don't know all possible event_type beforehand, you need to look at Dynamic Pivot in google.

 

[hneal98]

you can check out this response. I had kind of the same issue and this is the solution I received that worked great.

http://tek-tips.com/viewthread.cfm?qid=700545&page=6