What are you unioning together? Are you using sysobjects/syscolumns to get the column names?
I'd make a cursor loop and build the dynamic sql statement.....
let @dynamicsql = 'SELECT '
for each column in tablex
get @columnname
let @dynamicsql = @dynamicsql + @columnname + ' (select ' + @columnname + ' from tablex where id = 1), '
next
remove last comma
let @dynamicsql = @dynamicsql + 'from tablex where id = 1'
exec (@dynamicsql)
|