CREATE TABLE Names (Name VARCHAR(50)) GO INSERT Names SELECT 'A

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 / gopi muluka

4 Answers
6790 Views
I also Faced
E-Mail Answers

Answer Posted / gopi muluka

CREATE TABLE Names (Name VARCHAR(50))
GO
INSERT Names
SELECT 'A'
UNION
SELECT 'B'
UNION
SELECT 'C'
UNION
SELECT 'D'
GO

-- FIRST METHOD
DECLARE @Name VARCHAR(50)
SELECT @Name=ISNULL(@Name,'')+ COALESCE(Name,',')+',' FROM
Names
SELECT LEFT(@Name,LEN(@Name)-1)
GO
--SECOND METHOD
DECLARE @chrString as varchar(200)
SET @chrString=''
SELECT @chrString=@chrString + ',' + Name FROM Names

SELECT SUBSTRING(@chrString,2, LEN(@chrString))

GO
DROP TABLE Names

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a document index?

1010

Do you know clustered and non-clustered index?

963

What is the purpose of self join?

955

Explain differences between web edition and business edition?

119

What are temporal tables in sql server 2016?

868

How can we solve concurrency problems?

1036

Explain the categories of stored procedure?

921

What is the difference between ddl,dml and dcl commands?

1095

What are a scheduled jobs?

943

What is the filtered index?

1027

Do you know what are the properties of the relational tables?

1013

What is factless fact table? : sql server analysis services, ssas

1008

How do I find sql server instance name?

947

What is ms sql server service broker?

968

what is a live lock? : Sql server database administration

938