[This topic is migrated from our old forums. The original author name has been removed]
I am trying to use the pivot statement in SQL commander but it doesn't recognize it.
Is there any alternate code for transposing rows into columns?
(I don't want to use case when since I want to create a flexible code in which you don't have to know the distinct values takes by a column)