/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 views3 answers
Sql server get week dates from week number
SQL
7 votes147 views1 answer
Sql management studio display line numbers
SQL
0 vote139 views1 answer
In mysql workbench contnent not feching
SQL
1 vote148 views1 answer
Where date = max(date) in sql
SQL
1 vote147 views1 answer
How to see logical reads in sql server
SQL
0 vote195 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote157 views1 answer
On sql table data exists
SQL
41 votes233 views6 answers
Alter table add column in SQL Server
SQL
0 vote193 views1 answer
Mql5 datetime get hour
SQL
0 vote144 views1 answer
10000000000000000000 am to meters
SQL