Try this way! create table stest(num int,name varchar(10),value numeric

have table with two columns with datatypes as number and
varchar and the values in
A column like 1,2,3 AND B column values like a,b,c.
now need to display data in a single column as 1,a,2,b,3,c.

Question Posted / saravanan

8 Answers
14087 Views
IBM, Zensar, I also Faced
E-Mail Answers

Answer Posted / saravanan

Try this way!

create table stest(num int,name varchar(10),value numeric
(10,2));

insert into stest values(101,'SARAN',1000.58);
insert into stest values(102,'KALA',1200.18);
insert into stest values(103,'AYYA',3000.40);
insert into stest values(104,'RATNA',4000.57);

SELECT * FROM STEST;

declare @str varchar(2000);
set @str = null;
select @str=ISNULL(@str+',','')+ltrim(STR(num))+','+name
from stest
select @str;

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does sql support programming?

1006

How to add, remove, modify users using sql?

977

What is localdb mssqllocaldb?

1017

What are the string functions in sql?

922

What is a relationship and what are they?

1049

what is a field in a database ? : Sql dba

988

Which function is used to return remainder in a division operator in sql?

1073

How does stored procedure reduce network traffic?

965

How do I find duplicates in a single column in sql?

951

What are pl/sql cursor exceptions?

1035

Does execute immediate commit?

1152

What is a join query?

905

Is sql an operating system?

960

How many sql core licenses do I need?

881

What are the different types of a subquery?

980