Devart Forums

Posted: **Thu 24 Jan 2013 22:47**

Hi,

Was searching for something related to this on forum and could not find anything.

currently if I format the following code
Using version 4.0.61

Code: Select all

select 
row_number() over (order by cl.f1
       , cl.f2
       )
- 1 as f2
,cl.f3
,cl.f4
from #clients cl

I get this output

Code: Select all

select row_number() over (order by cl.f1
       , cl.f2
       )
       - 1 as f2
,cl.f3
,cl.f4
from #clients cl

but the desired output is

Code: Select all

select row_number() over (order by cl.f1
                                  ,cl.f2
                         )
       - 1 as f2
      ,cl.f3
      ,cl.f4
from #clients cl

Is there any combination of settings that will format the above, or is this something that has been overlooked and will need to be addressed?

Thanks

Posted: **Fri 25 Jan 2013 17:54**

We are currently reviewing the issue you have posted and will contact you as soon as possible.

Posted: **Thu 14 Feb 2013 11:58**

Formatting of the ORDER BY clause within the OVER clause appears to be not supported in dbForge SQL Complete.

However, we added such suggestion on our UserVoice forum and voted for it on your behalf: http://devart.uservoice.com/forums/8789 ... thin-over-

We do this in order to make a proper roadmap for next product releases.

You will receive a confirmation e-mail to activate your UserVoice account.
Here you will be able to change the number of votes for this suggestion.
Also you will be able to vote for other suggestions or add new ones.

We notify you that your e-mail address will not be visible on the forum.

Devart Forums

SQL Complete - undesired output formatting ranking functions

SQL Complete - undesired output formatting ranking functions

Re: SQL Complete - undesired output formatting ranking functions

Re: SQL Complete - undesired output formatting ranking functions