SQL build column name from results in query

Question

I have a table with 60 columns: [Actual_Deb01],[Actual_Deb02],[Actual_Deb03],.......,[Actual_Deb60]

one of the columns in the queries is period and I only want to fetch the actual_debt for the period.

how can I use the period to build the actual_deb col name I want to fetch. something like:

SELECT  Actual_Deb04],
        period,
        ['Actual_Deb'+period]
FROM table

period in the above is 03 so I want the query to effectively be:

SELECT  [Actual_Deb04],
        period,
        [Actual_Deb04]
FROM table

Can i do this in the query syntax?

Thanks in advance as always, R

TheGameiswar · Accepted Answer · 2016-03-13 07:02:23Z

1

you can do it with dynamic sql,but what if you have multiple periods ??

declare @sql nvarchar(max)
set @sql=
'select
      [Actual_Deb04],period ,'
      +'Actual_Deb'+period+' FROM table;'

  exec(@sql)

answered Mar 13, 2016 at 7:02

TheGameiswar

29k9 gold badges67 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1