Formatting bug when using windowed functions

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Formatting bug when using windowed functions

Postby eugenen » Tue Nov 12, 2013 12:22 pm

I would not expect the t.* or the tables to be aligned/placed where they are. If you comment the first line i.e the sum then it formats properly
Code: Select all
select
   sum(t.Amount) over (),
                  t.*
from
                  payment.Applications as a
                  inner join payment.Transactions as t
                     on t.ApplicationId = a.ApplicationId
where
                  a.ExternalId = '506EAE98-5C08-49D6-B6FB-59710A00000F'


select
   --sum(t.Amount) over (),
   t.*
from
   payment.Applications as a
   inner join payment.Transactions as t
      on t.ApplicationId = a.ApplicationId
where
   a.ExternalId = '506EAE98-5C08-49D6-B6FB-59710A00000F'
eugenen
 
Posts: 5
Joined: Tue Feb 23, 2010 11:13 am

Postby Aaron Law » Tue Nov 12, 2013 7:47 pm

Thanks for reporting this, it definitely looks wrong to me and will be fixed in the next update to prompt which should be released next week.

In the meantime you can download a private build (only had some basic testing) with a fix from here.
Aaron Law
 
Posts: 262
Joined: Fri Jun 28, 2013 10:56 am
Location: Red Gate Software


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests