/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

1 vote144 views1 answer
Ora-01950 no privileges on tablespace
SQL
0 vote112 views1 answer
How to locate pg_hba.conf file
SQL
4 votes94 views3 answers
Oracle sql first day of quarter
SQL
-1 vote111 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
4 votes124 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote113 views1 answer
How to get one year old query from plan cache
SQL
0 vote106 views1 answer
How to tell if i have lactose intolerance
SQL
16 votes102 views6 answers
Install sqlite3 python
SQL
1 vote106 views3 answers
Psql fatal database does not exist
SQL
0 vote101 views1 answer
Insert or update sql query
SQL