Hi,
I want to execute some dynamic sql with stored procedure,
I bulid this dynamic sql, then execute

like:

declare @sql varchar(200)

set @sql='select ' + @fields + 'from ' + @table
exce @sql

but I want to get this execute result

how to do?

do I need use some temp table to store this data?

Thanks, Robert Snoog (softsea.com)