/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 votes144 views2 answers
Check data in table mysql
SQL
0 vote182 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote138 views2 answers
Select a row include list of array with join two table SQL
SQL
1 vote158 views2 answers
Mysql insert generate serie
SQL
0 vote133 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
1 vote136 views1 answer
Primary key with prefix sql
SQL
1 vote146 views2 answers
Copy database mysql
SQL
-1 vote141 views1 answer
Get id from just inserted row mysql server python
SQL
2 votes138 views1 answer
How to find constraints on a table in oracle
SQL
0 vote156 views1 answer
Sqlite version check
SQL