Using a variable to rename a column

• Curtis Finney

  Newbie

  Points: 1

  More actions

  June 22, 2004 at 11:06 am

  #83248

  Does anyone know how to rename a column using a variable? 

  DECLARE  @user1 varchar(50)

  SELECT @User1 = 'New_Column_Name'

  SELECT User1 AS @user1

  The AS clause doesn't work, nor does an = sign.  The problem is that I have is that table 1 defines the labels of user defined fields in table 2 I am querying from.  I would like the output to use the from table 2 to have the proper column lables as defined in table 1.

  Thanks

  Curtis

• martin bigi

  Grasshopper

  Points: 16

  More actions

  June 22, 2004 at 12:24 pm

  #511496

  DECLARE  @user1 varchar(50)

  SELECT @user1 = 'New_Column_Name'

  declare @sentencia_sql nvarchar(1000)

  declare @Sal int

   

  select @sentencia_sql='SelECT User1 AS ' + @user1 + '

  from _user'

  EXECUTE @Sal=sp_executesql @sentencia_sql

  --if @Sal<>0 goto manejo_error