Dynamic column name?

• Ulysses_Infinity

  SSCrazy

  Points: 2588

  More actions

  July 17, 2012 at 9:59 am

  #276057

  Hi,

  I have a variable (date), that I want to use as a column header. Is this possible?

  Regards,

  Jason

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  July 17, 2012 at 10:06 am

  #1513693

  Out of interest, can you explain why you need this?

  Should be easy enough via some dynamic SQL - not sure it will be possible otherwise.

  ---

• BrainDonor

  SSCoach

  Points: 19262

  More actions

  July 17, 2012 at 10:07 am

  #1513695

  If you mean, creating a column that has a name which is a specific date, then yes it is possible by using dynamic sql (formating of the name may be an issue).

  However, it is an odd thing to require - why do you want to create such a specific column?

  Steve Hall
  Linkedin
  Blog Site

• thbaig

  Hall of Fame

  Points: 3006

  More actions

  July 19, 2012 at 9:37 am

  #1514949

  not sure about your exact problem.

  can't you use "AS" in your select statement ?

  select column as Date from ...

• mar1jxm

  Ten Centuries

  Points: 1303

  More actions

  July 20, 2012 at 1:36 pm

  #1515730

  Yes you can.

  Just use a dynamic query. Something like this

  DECLARE @SQL_string AS varchar(200)

  DECLARE @Column_Name AS varchar(20)

  SET @Column_Name = 'Customer_Number'

  SET @SQL_string = 'SELECT CST_Num AS ' + @Column_Name + ', ' + CHAR(13) +

  'Revenue, Cost FROM CST_REV_TABLE'

  EXEC (SCR_TC_PREP)

  Good Luck!

  
  Jacob Milter

• mar1jxm

  Ten Centuries

  Points: 1303

  More actions

  July 20, 2012 at 1:48 pm

  #1515737

  Ooops!

  Just realized that you need to use date variabe...

  Here it is:

  DECLARE @SQL_string AS varchar(200)

  DECLARE @Column_Name AS varchar(20)

  DECLARE @Date_Value AS Datetime

  SET @Date_Value = GETDATE()

  SET @Column_Name = 'Customer_Number'

  SET @SQL_string = 'SELECT CST_Num AS ' + @Column_Name + ', ' + CHAR(13) +

  'Revenue AS ' + 'Revenue_As_OF_' + REPLACE(CONVERT(VARCHAR(10),GETDATE(),101),'/','') + CHAR(13) +

  ', Cost FROM CST_REV_TABLE'

  --EXEC (@SQL_string)

  PRINT (@SQL_string)

  
  Jacob Milter