/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 votes131 views1 answer
Sql group by different columns
SQL
1 vote177 views1 answer
Mysql decimal allow negative values?
SQL
2 votes156 views1 answer
Plsql block
SQL
0 vote212 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
4 votes175 views5 answers
Primary key
SQL
0 vote157 views1 answer
Check psql validity function
SQL
1 vote170 views3 answers
Mysql disable foreign keys check
SQL
4 votes191 views1 answer
Oracle nls_date_format
SQL
0 vote185 views1 answer
Providername system.data. mysql
SQL
0 vote163 views1 answer
How to retrive the today date sql
SQL