Red Gate forums :: View topic - OVER () formatting
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

OVER () formatting

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
chrisw13



Joined: 01 Jul 2013
Posts: 3

PostPosted: Mon Jul 01, 2013 4:09 pm    Post subject: OVER () formatting Reply with quote

When formatting TSQL with a n OVER() statement, the following line is aligned with the () rather than to the left...

An arbitrary example. You'll need to view in fixed width font (ssms) to see alignment.

Code:

-- sys.indexes alligned propertly under *
SELECT  *
FROM    sys.indexes


-- qty2, * and sys.indexes improperly alligned
SELECT  qty = COUNT(*) OVER ()
                            ,qty2 = SUM(CAST(is_unique AS INT)) OVER ()
                                                                     ,*
FROM                                                                  sys.indexes

-- Using comments to help formatting, but there's still a stair step affect
SELECT  qty = COUNT(*) OVER --
        ()
        ,qty2 = SUM(CAST(is_unique AS INT)) OVER --
         ()
         ,*
FROM      sys.indexes

-- More comments to provide more accurate formatting
SELECT  qty = COUNT(*) OVER --
/*  */ ()
       ,qty2 = SUM(CAST(is_unique AS INT)) OVER --
/*  */ ()
       ,*
FROM    sys.indexes


Currently using SqlPrompt 6.0.0.71 EAP, but same issue in v5.x
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Tue Jul 02, 2013 5:55 pm    Post subject: Reply with quote

This would be considered a formatting feature request.
You can direct feature requests to our uservoice forums.
http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions
These forums are actively monitored by our development team and allow our users to request features and vote on them.
If a feature receives a significant amount of votes or is deemed to have merit development may include the feature in a future release.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group