RE: [Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)

2005-03-29 Thread Agus Riyadi
-Village] SQL Statement (crosstable / pivot table) Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result

[Axapta-Knowledge-Village] SQL Statement (crosstable / pivot table)

2005-03-29 Thread Anton Tjiptadi
Hi guys, I want to create crosstable or pivot table from my data, for ex : Branch ItemAmount -- - --- Branch1 ItemA 10 Branch1 ItemB 10 Branch2 ItemB 10 Expected result: Item Branch1 Branch2 - ---