/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

18 votes206 views3 answers
Find column name in database
SQL
20 votes217 views6 answers
Change password in mysql
SQL
2 votes207 views1 answer
Set username and password for postgresql database
SQL
-1 vote291 views1 answer
Minus vs except in sql
SQL
0 vote203 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL
-1 vote213 views3 answers
How to restart mysql in linux
SQL
0 vote312 views1 answer
Delet all record statment sql
SQL
0 vote212 views1 answer
Reset keys in sql
SQL
0 vote191 views1 answer
How to connect postgresql database with java
SQL
0 vote219 views1 answer
Sql doesn't contain
SQL