Thanks for the code. I ended up using an example shown in the link below since the data that i needed to pivot was string data. Worked quite nicely.

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/4ac19fe5-be05-479f-bcc2-8fdfa6c1ae1f

Hello,

is it possible for you to post the code that you used in order to solve this issue. i have a similar problem that i need to tackle.

Thanks,

C.