I had similar issue..

You can create a temp table and populate the table with id,email,...

i.e...

INSERT INTO temp

exec(@query)

select * from temp

drop table temp

now the column name will be available in the...