DECLARE @chrString as varchar(200) select @chrString=@chrString + '

hi,
i have a table called names and field name
select * from names
name
a
b
c
d

i want to display like this
name
a,b,c,d
how it is possible

Regards
Baiju

Question Posted / kulwinder

4 Answers
6631 Views
I also Faced
E-Mail Answers

Answer Posted / kulwinder

DECLARE @chrString as varchar(200)

select @chrString=@chrString + ',' + Name from Names

? @chrString

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why do we use non clustered index?

1004

How to assign null values to variables or columns?

907

Determine when to use stored procedure to complete sql server tasks?

985

can SSRS reports Cache results?

136

What are the acid properties?

934

Is null vs coalesce?

814

What is cursors? And what are the different types of cursor?

1083

What is efficiency data?

899

What is buffer cash and log cache in sql server?

1051

Which data type columns are the best candidates for full-text indexing?

916

What is report server project?

133

What is database mirroring?

1037

How you provide security to cube? : sql server analysis services, ssas

920

How do I create a trace in sql server?

957

What extended events?

948