/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 votes280 views1 answer
SQL IF ELSE
SQL
0 vote282 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote260 views1 answer
Oracle last connection
SQL
3 votes258 views1 answer
Oracle nextval
SQL
0 vote268 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote305 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote283 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote287 views1 answer
Selecting from a view SQL
SQL
0 vote222 views1 answer
Import sql file in mysql linux
SQL
1 vote286 views1 answer
Too many connections mysql
SQL