/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 vote144 views1 answer
Apex ORA-20999
SQL
2 votes144 views1 answer
Mysql increment value by 1 in update
SQL
1 vote110 views1 answer
Ms sql - add one hour to time
SQL
0 vote140 views1 answer
If null don't update
SQL
0 vote153 views1 answer
Trigger vérifier stock
SQL
0 vote141 views1 answer
Ms Sql set us timezone
SQL
4 votes151 views1 answer
Mac install mysql
SQL
1 vote151 views1 answer
Postgres regex remove special characters
SQL
5 votes149 views1 answer
Sql check if date is between 2 dates
SQL
20 votes147 views3 answers
SQL query rename table
SQL