/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

0 vote129 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote137 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote138 views1 answer
Postgresql default value boolean
SQL
0 vote133 views2 answers
How to update date in oracle
SQL
1 vote136 views1 answer
Mysql remove last empty newline
SQL
2 votes137 views3 answers
Current month mysql query
SQL
1 vote156 views1 answer
Tsql create unique index composite
SQL
0 vote137 views2 answers
How to know the character set of an oracle databes
SQL
0 vote148 views1 answer
Sql server synonym
SQL
0 vote121 views1 answer
Sub blocks in sql
SQL