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
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prasanna
create procedure loopcure
as
BEGIN
declare @a int, @b varchar(020), @l int, @c varchar(020),
@D varchar(020)
SET @D = ''
declare loopcur cursor for select id from names
open loopcur
fetch next from loopcur into @b
while @@fetch_status = 0
begin
select @C = LTRIM(RTRIM(@B)) + ','
select @D = LTRIM(RTRIM(@D)) + LTRIM(RTRIM(@C))
fetch next from loopcur into @b
end
close loopcur
deallocate loopcur
select @d = left(@d, len(@d)-1 )
select @d as final
END
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / kulwinder
DECLARE @chrString as varchar(200)
select @chrString=@chrString + ',' + Name from Names
? @chrString
Is This Answer Correct ? | 1 Yes | 1 No |
What is repeatable read?
What is BLOCK statements in SQL?
What is ems sql management studio? : sql server management studio
What is de-normalization in sql database administration? Give examples?
Different types of keys in SQL?
Why use stored procedures in sql server?
What is normalization and its types?
Do you know what are the ways available in sql server to execute sql statements?
What is the difference between push and pull subscription? : sql server replication
What are different types of raid configurations? : SQL Server Architecture
What is ms sql server triggers?
What are the advantages of paper records?