how to combine rows in sql server procedure

Solutions on MaxInterview for how to combine rows in sql server procedure by the best coders in the world

showing results for - "how to combine rows in sql server procedure"
Kasper
27 Aug 2017
1select id, a.name + coalesce('/'+b.name, '') + coalesce('/'+c.name, '')
2from myTable a
3left outer join myTable b on a.id=b.id and b.seqno = 2
4left outer join myTable c on a.id=c.id and c.seqno = 3
5where a.seqno = 1;
6
similar questions