Want to show Dynamic column name in SQL SERVER 2008

Question

Hello All

I have a problem
I want to show Column name like 'Jan-2010','Feb-2010' and so on.

declare @Year int = 2012
declare @a varchar(20)
set @a= CAST('jan-' as varchar(20))+ Cast(@Year as Varchar(20))
print @a
select ColumnName as @a

The 'Jan-','Feb-','Mar-' are hard coded, but year should come dynamically.
and column name should appear like 'Jan-2010','Feb-2010' if Year is 2010,
if Year is 2011, it should show like 'Jan-2011','Feb-2011' and so on.

Pls help as soon as possible.
Thanks in Advance.
Regards
Anurag

Amar Arya · Answer

I hope this will help you... declare @Year DateTime Set @Year='01-01-2012' Select replace(substring(CONVERT(varchar@Year106)3LEN(CONVERT(varchar@Year106)))' ''-')

Jignesh Trivedi · Answer

hi I think you can use Inbuilt YEAR function in this case. declare @Year int = year(GETDATE()) declare @a varchar(max) set @a= CAST('jan-' as varchar)+ Cast(@Year as Varchar) print @a if your date is come from Table column then try declare @Year int select @Year= year(tableDate) from table_1 where Pkid =1 declare @a varchar(max) set @a= CAST('jan-' as varchar)+ Cast(@Year as Varchar) print @a hope this will help you.