i want to print 2 column value in a single column using sql query.

Question

0.00/5 (No votes)

See more:

i have 2 table student and matrix

in student table columns are-

studentid studentname
1001 ashish
1002 shiva
1003 hasan
1004 hina

and in matrix table columns are-

seatno studentid
1 1001
2 1002
3 1003
4 1004

i want to print 2 column value in a single column using sql query like

student

1,ashish
2,shiva
3,hasan
4,hina

Posted 11-Apr-14 2:58am

TCS54321

Add a Solution

4 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

abhishek_singh · Answer 1 · 2014-04-11T03:10:00

Solution 2

try this one...

SQL

Select
cast(seatno as varchar) + ',' + Studentname
from StudentTable s
inner join MatrixTable m on m.Studentid = s.studentID

Posted 11-Apr-14 3:10am

abhishek_singh

member33 · Answer 2 · 2014-04-11T03:11:00

Solution 3

SQL

castSeatnno to varchar 
 That should work

Select
cast(seatno as varchar(10)) + ',' + Studentname
from StudentTable s
inner join MatrixTable m on m.Studentid = s.studentID

Posted 11-Apr-14 3:11am

member33

Comments

TCS54321 11-Apr-14 9:16am

its working... thanku

member33 · Answer 3 · 2014-04-11T03:01:00

Solution 1

hey you could use this query

Select
seatno + ',' + Studentname
from StudentTable s
inner join MatrixTable m on m.Studentid = s.studentID

Posted 11-Apr-14 3:01am

member33

Comments

TCS54321 11-Apr-14 9:05am

Conversion failed when converting the varchar value ',' to data type int.

this is a error when i run this query

Peter Leow · Answer 4 · 2014-04-11T03:14:00

Solution 4

SQL

select convert(varchar, seatno) + ',' + studentname
from student s join matrix m on
s.studentid = m.studentid

Posted 11-Apr-14 3:14am

Peter Leow

i want to print 2 column value in a single column using sql query.

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0

i want to print 2 column value in a single column using sql query.

4 solutions

Solution 2

Solution 3

Solution 1

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us