I created a table for example:
I have the following content:
select * from table_t;
Youneedtogetthefollowingresult:
In MySql I use the following query:
select group_concat(concat_ws(' - ',id,descri)) id_descri, tipo from table_t group by tipo;
What about SqlServer? Thanks!