plz Check this...

I think it is useful for you

declare @lsstr as varchar(750)

declare @lssql as varchar(500)

set @lsstr = ''

select @lsstr = @lsstr + ',[' + 'C' + convert(varchar(5),row_number() over(order by date))...