Print Thread
Pivot keyword on newline in beautifier
#48766 03/13/14 01:55 PM
Joined: Apr 2003
Posts: 32
lausanne, Switzerland
roselan Offline OP
Member
OP Offline
Member
Joined: Apr 2003
Posts: 32
lausanne, Switzerland
Heyhey,

it would be nice that Pivot keyword got it's own new line in the beautifier

instead of
SQL Query
select * 
from (select thing
        from stuff 
        join more_stuff 
       where some_random_things = are_realy_long_meaninless_names) pivot count(*) for stuff in (bunch_of_things);

would be
SQL Query
select * 
from (select thing
        from stuff 
        join more_stuff 
       where some_random_things = are_realy_long_meaninless_names)
pivot count(*) for thing in (bunch_of_things);

if it's already possible, could you please tell me how?

thanx++


there is no fork
roselan
Re: Pivot keyword on newline in beautifier
roselan #48772 03/14/14 10:25 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
This is currently not possible. It is on the list of enhancement requests though.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.035s Queries: 14 (0.010s) Memory: 2.5017 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-05-17 15:42:23 UTC
Valid HTML 5 and Valid CSS