you can try this using dynamci sql like this.

First create a temp table with  a dummy column name and later on add columns dynamically on the fly.

see sample code...