Hi Friend, If u use SQLSERVER 2005 u can try like this............ CR

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 / soorai ganesh

4 Answers
6789 Views
I also Faced
E-Mail Answers

Answer Posted / soorai ganesh

Hi Friend,

If u use SQLSERVER 2005 u can try like this............

CREATE TABLE EMP ( ENAME VARCHAR(25))

INSERT INTO EMP VALUES('Ganesh')
INSERT INTO EMP VALUES('Narendra')
INSERT INTO EMP VALUES('Rinku')
INSERT INTO EMP VALUES('Selvam')
INSERT INTO EMP VALUES('Kirti')

SELECT REPLACE(REPLACE(
( SELECT ENAME AS EmpName FROM EMP FOR XML PATH ('') ) ,'<EmpName>',''),'</EmpName>',',')

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How optimize sql query with multiple joins in sql server?

875

What is explicit cursors?

1049

Define Unique Key?

986

Explain the cursor lock types?

1029

Determine how to use the inserted and deleted pseudo tables?

972

What is function of master database?

114

What is store procedure?

1041

What are different type of Collation Sensitivity?

982

What is entity data services?

1037

What is a result set object returned by odbc_exec()?

1003

Do you know what are the restrictions that views have to follow?

1063

Explain what are sparse columns?

970

How to get nth highest salary from employee table.

1149

What is db stored procedure?

856

What happens when unicode strings concatenate with non-unicode strings?

1065