/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 votes273 views2 answers
Mysql select database
SQL
0 vote252 views1 answer
Oracle drop default value
SQL
1 vote270 views1 answer
Oracle stop
SQL
0 vote267 views1 answer
Mysql export and import
SQL
0 vote258 views1 answer
How to use lower case in mysql
SQL
1 vote249 views1 answer
Create sample data postgresql
SQL
0 vote274 views1 answer
Get a list of tables and the primary key
SQL
-1 vote276 views1 answer
Mysql select count if contains
SQL
0 vote278 views1 answer
Insert set mysql
SQL
15 votes264 views6 answers
Psql
SQL