/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 vote152 views1 answer
Sql set max value in column
SQL
2 votes159 views1 answer
Create delete procedure mysql
SQL
4 votes132 views1 answer
Oracle table statistics last analyzed
SQL
4 votes146 views1 answer
Mac install mysql
SQL
0 vote137 views1 answer
Sql contains numeric characters
SQL
1 vote151 views1 answer
Select not matching data from two tables
SQL
0 vote136 views1 answer
Mysql set column equal to another automatic
SQL
2 votes152 views1 answer
Query any digits record
SQL
5 votes149 views2 answers
Oracle apex debug mode
SQL
0 vote98 views1 answer
Kannst du deine finger trainieren
SQL