How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

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)
2 CommentsSorted by Oldest First
[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
Comments to this discussion are now closed!
More topics in Support
See all 1311 topics