Formatting bug when using IIF

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

Formatting bug when using IIF

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

if you take the following statement, the spaces are intenional white spaces, and format it it does not format the IIF as nicely as the datediff

Code: Select all
select
   iif(     rrbr.ColumnName = 'Test',    0,       1),
   datediff(       day,         getdate(),       getdate()    )
from
   recon.ReconResultsByRow as rrbr

select
   iif(
   rrbr.ColumnName = 'Test',    0,       1),
   datediff(day, getdate(), getdate())
from
   recon.ReconResultsByRow as rrbr
eugenen
 
Posts: 5
Joined: Tue Feb 23, 2010 11:13 am

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

This'll be fixed in the next release of prompt (and is also in the private build I mentioned on your other post)
Aaron Law
 
Posts: 261
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