/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

2 votes296 views1 answer
Sql missing records from another table
SQL
0 vote308 views1 answer
How to list function in psql
SQL
0 vote289 views4 answers
Mysql select bottom 10 rows
SQL
1 vote270 views1 answer
Mysql select utc time in eastern time
SQL
0 vote295 views1 answer
Mysql drop vs delete
SQL
4 votes298 views2 answers
Convert utc to est sql
SQL
3 votes293 views2 answers
Oracle apex view logs
SQL
2 votes289 views1 answer
Apex execute batch job
SQL
5 votes298 views3 answers
Mysql update field from one table to another
SQL
1 vote305 views3 answers
Execute sp in sql server
SQL