combine the same id in mysql so one colomn and display it in gridview asp.net
example
id provinsi_id kab_id sektor_id
1 2 31 1
2 2 31 2
3 2 31 3
and I want the results like this.
id provinsi_id kab_id sektor_id sektor_id sektor_id
1 2 31 1 2 3
Loading
Saineshwar BageriPosted Mar 23, 2015, 12:35 AM
http://sqlhints.com/2014/03/10/pivot-and-unpivot-in-sql-server/
hothorasman panjaitanPosted Mar 22, 2015, 10:19 AM
Saineshwar BageriPosted Mar 22, 2015, 7:50 AM