/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 vote325 views1 answer
Mysql grant user wildcard database
SQL
2 votes349 views1 answer
Sql string_agg
SQL
0 vote321 views1 answer
Download mysql database to excel in android studio
SQL
0 vote418 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
1 vote324 views2 answers
Replace text in sql
SQL
5 votes377 views1 answer
Oracle source query
SQL
6 votes367 views2 answers
Mysql convert timestamp to date
SQL
0 vote371 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
6 votes334 views4 answers
Delete table sqlite
SQL
1 vote351 views1 answer
Deleting database in sql
SQL