/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 vote120 views1 answer
Last date for each user sql
SQL
0 vote153 views1 answer
Many rows to 1 string mysql
SQL
1 vote77 views1 answer
Python escape string for sql
SQL
1 vote170 views1 answer
How to check all scheduled jobs in oracle
SQL
2 votes127 views2 answers
Mysql count rows returned
SQL
-1 vote127 views1 answer
Export mysql table to file
SQL
7 votes93 views1 answer
Mysql load data infile csv
SQL
25 votes126 views3 answers
How to use a database to see tables mysql
SQL
7 votes136 views2 answers
Create mysql user
SQL
0 vote88 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL