/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 votes165 views1 answer
Sql as
SQL
0 vote128 views1 answer
Flask_sqlalchemy install
SQL
8 votes175 views1 answer
Mysql limit rows
SQL
0 vote174 views1 answer
Drop view in mysql
SQL
1 vote204 views3 answers
Alter schema sql server
SQL
0 vote168 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote163 views1 answer
Add colum date in sql
SQL
4 votes169 views4 answers
Oracle tablespace tables list
SQL
3 votes212 views2 answers
Wp do sql query from function
SQL
0 vote177 views1 answer
Mysql exception output
SQL