Hi

Is it possible to return a table that its aliases are changing according to
varaiables ?
For example:  I would like to use something like (ofcourse it doesn't work).


declare @p1,@p2 varchar(30)
set @p1 ='blhablha'
set @p2 ='hghfg'

select field1 as @p1, field2 as @p2 from table1

thanks

Selecting when Dates in where clause
"If you want a lot of information, one has to use cursors."
How to get variable number of rows on one row.
Returning a value from query
slow Select query specifying daterange using variables.