It has been my experience that this is a problem that is better solved on the client or mid-tier and not the server.

-Mike

>I'm trying to write a stored proc to create a temporary flat file which some chrystal reports can be run from.
>I want to use the values from a particular field as the headers for the fields in my flatfile table.
>So I create a table with only one column which is an increment one.
>Then I create a cursor, fill it with the data I need and then fetch the records from it one by one.
>For each record I want to append a field to the flatfile table and call the field whatever the data in the cursor field is.
>In vis fox you could use macro substitution to do something like this.
>Is there something similar in sql server?
>
>
>Phil.