How to make dynamic column name to the result?

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

As far as I know, you cannot do this without resorting to dynamic sql. Why do you want to do this?

Loner SSC-Insane Points: 21279 More actions · Answer 2

select ('adfd' + cast(18 as varchar(3))) as 'cvr < '

Is this what you want? The result is 'adfd18'

coby_cai SSC-Addicted Points: 439 More actions · Answer 3

Thanks but I want the result to be

cvr < 18

------------

adfd

I just want to make the column name to change by the value of the integer number, such as 18 above.

Thanks,

coby

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Nothing changed. You still have to use dynamic sql to do this. But then again you shouldn't need dynamic sql. So what do you need to do???

michaela SSCertifiable Points: 5649 More actions · Answer 5

You cannot use "<" into a column name.

CREATE TABLE [dbo].[tTest](

[tcolumn] [varchar](20)

) ON [PRIMARY]

GO

insert into dbo.tTest (tcolumn) values ('adfd18')

go

declare @sqlString as nvarchar(100)

declare @var as int

set @var=18

set @sqlString='select tcolumn as cvrLessThan'+ltrim(cast(@var as varchar(3)))+' from dbo.tTest'

exec sp_executesql @sqlString

Good luck!

coby_cai SSC-Addicted Points: 439 More actions · Answer 6

SSC-Addicted

Points: 439

December 3, 2006 at 10:33 pm

All,

Thanks a lot for your suggestions.

coby

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

That works for me!

Select 'Demo' AS "Strange column < name"

Ray M SSC-Insane Points: 21093 More actions · Answer 8

Why are you trying to do this.

you should do all this kind of stuff in the presentation layer.

You cannot concatenate a string to give you a "Dynamic" Column name. (Unless you use dynamic sql as suggested)