Formatting bug when using IIF

Provides intelligent code completion for SQL Server editors.

Formatting bug when using IIF

Postby eugenen » Tue Nov 12, 2013 11:32 am

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
   iif(     rrbr.ColumnName = 'Test',    0,       1),
   datediff(       day,         getdate(),       getdate()    )
   recon.ReconResultsByRow as rrbr

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

Postby Aaron Law » Tue Nov 12, 2013 6: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: 436
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Return to SQL Prompt

Who is online

Users browsing this forum: No registered users and 2 guests