ansaurus

Question

Answer 1

A:

Is that what you mean?

declare @variable nvarchar(250)

select @variable = f1 + ',' + f2 + ',' f3 from table

Tzury Bar Yochay 2009-09-24 06:28:40

not this way, if i have fieldsFileid | FileNum---------------1 00011 0002i want it asFileid | FileNum---------------1 0001,0002

2009-09-24 06:34:57

pls consider Fileid,filenum as the fields of a table and the rest its values

2009-09-24 06:37:05

I want to concatenate the row values based on a Field for eg(FileID)

2009-09-24 06:46:21

Answer 2

+1 A:

How about this:

select FileId, REPLACE(FileNum, ' ', ', ') from table

Noah Heldman 2009-09-24 07:04:49

DECLARE @FullNames VARCHAR(100)SELECT @FullNames = ISNULL(@FullNames,'') + FileNum + ', ' FROM table

2009-09-24 07:44:29

I did it using above code,thanks

2009-09-24 07:45:09

how to set the columnvalues to a variable in store procedure