Start a new topic

SQL Commander - pivot statement

[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)

[This reply is migrated from our old forums. The original author name has been removed]

Re: SQL Commander - pivot statement
Hi, Which database do you use ? I've already used the pivot function with DBViz for MS SQLServer and all is working fine.
[This reply is migrated from our old forums.]

Re: SQL Commander - pivot statement
Hi, Can you please give more details what SQL command you are using and what database is used? Regards Roger