/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 vote240 views1 answer
What is common table expression in sql
SQL
2 votes199 views1 answer
Set username and password for postgresql database
SQL
0 vote192 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote201 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote205 views1 answer
Sql server change schema of a table
SQL
13 votes197 views2 answers
Get date from now() mysql
SQL
12 votes206 views4 answers
Mysql version
SQL
-1 vote195 views1 answer
Auto increment psql not primary key
SQL
14 votes215 views6 answers
Auto_increment mysql
SQL
0 vote189 views1 answer
Get first name and last name from full name string in SQL
SQL