/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 votes318 views2 answers
Oracle grants
SQL
0 vote334 views1 answer
Mssql disable foreign key constraint
SQL
0 vote322 views1 answer
With_for_update sqlalchemy
SQL
0 vote317 views1 answer
Sql server union if table exist
SQL
2 votes289 views2 answers
Select multiple tables mysql
SQL
3 votes320 views2 answers
Get current year sql
SQL
0 vote339 views1 answer
Insert into table with only identity column
SQL
16 votes374 views1 answer
Mysql mediumint max value
SQL
0 vote317 views1 answer
Sql select max value for each group
SQL
0 vote332 views1 answer
How to get nth number in sql
SQL