query projection - dynamically generating

• macaiba

  SSC Rookie

  Points: 31

  More actions

  July 2, 2002 at 1:48 pm

  #78341

  Hi,

  is it possible to dynamically generate a query projection. That is: I would like to dynamically decide what columns of a table I would select.

  I tried something like:

  ---

  declare @p char

  set @p = '*'

  select @p

  from FOOBAR

  ---

  and got :

  *

  *

  *

  *

  *

  *

  ...

  TIA,

  João Macaíba.

• Sachin Dedhia

  SSCrazy

  Points: 2104

  More actions

  July 3, 2002 at 11:07 pm

  #432102

  You require to use EXEC(...)

  DECLARE @col varchar(10)

  SET @col = 'UR_COLUMN'

  EXEC ( 'SELECT ' + @col + ' FROM FOOBAR' )

  Alternatively,

  DECLARE @sql varchar(50), @col varchar(10)

  SET @col = 'UR_COLUMN'

  SET @sql = 'SELECT ' + @col + ' FROM FOOBAR'

  EXEC ( @sql )

  Hope this helps you...

  IF U DON'T SEEK PERFECTION, U CAN NEVER REACH EXCELLENCE!!!

  SD

  
  

  Regards,
  Sachin Dedhia

• khenry

  Valued Member

  Points: 50

  More actions

  July 4, 2002 at 3:15 am

  #432105

  Or use sp_executesql N'select ' + @FieldList + N' from table' on 2000