/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 vote191 views1 answer
Mysql timeout 30 seconds
SQL
14 votes248 views1 answer
Oracle alter table add column not null
SQL
4 votes216 views2 answers
Oracle unliock account
SQL
0 vote239 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
3 votes232 views1 answer
Select count from table mysql
SQL
0 vote213 views1 answer
Mysql select all table that have field names
SQL
11 votes190 views1 answer
Reset identity sql server
SQL
0 vote221 views1 answer
Oracle current session details
SQL
0 vote241 views1 answer
Learnxinyminutes sql
SQL
0 vote246 views1 answer
Postgresql port 5432 not open
SQL