/SQL/How to combine rows in sql server procedure

How to combine rows in sql server procedure

select id, a.name + coalesce('/'+b.name, '') + coalesce('/'+c.name, '')
from myTable a
left outer join myTable b on a.id=b.id and b.seqno = 2
left outer join myTable c on a.id=c.id and c.seqno = 3
where a.seqno = 1;

Source: stackoverflow.com

Similar codes

-1 vote236 views2 answers
Import data from excel to sql server automatically
SQL
4 votes217 views3 answers
Drop Table Oracle
SQL
0 vote209 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote219 views2 answers
How to relationship query two different tables in MySQL
SQL
1 vote224 views1 answer
Importance of comment in mysql
SQL
13 votes207 views5 answers
Oracle list tables
SQL
0 vote226 views1 answer
Mysql last 6 months
SQL
0 vote215 views1 answer
Tsql cmd exec script from file
SQL
2 votes225 views1 answer
Columns Present in a table
SQL
1 vote223 views3 answers
Getdate function in postgresql
SQL