/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 vote285 views1 answer
Postgresql linux password
SQL
0 vote281 views1 answer
Sql use with to get value counts and percentages
SQL
1 vote273 views1 answer
Copy postgres table from one schema into another
SQL
8 votes279 views5 answers
Grant permission in postgres
SQL
0 vote313 views1 answer
Look at running processes redshift
SQL
42 votes345 views6 answers
Sql query duplicate rows
SQL
2 votes267 views2 answers
Checking data type in sql server
SQL
5 votes278 views4 answers
Rollback to in sql
SQL
4 votes271 views2 answers
Mysql how to change default charset
SQL
0 vote297 views1 answer
Comparing with today and yesterday record in sql query
SQL