IIF

torsten.strauss

Hi Redgate Team,

SQL Prompt formats the following code like this

SELECT
	iteration, file_id, NAME, vlf_sequence_number, vlf_active, vlf_create_lsn
FROM dbo.db_log_info
ORDER BY
	iteration
, IIF  (vlf_sequence_number > 0, 0, 1)
,	vlf_sequence_number * -1 DESC
GO

IIF is not aligned and has a space between.

Thanks for fixing this.

Torsten

Version 9.1.1.4243

krzysztofkroczak

Hi @torsten.strauss,

Sorry for your inconvenience. I've identified the problematic option (probably it is Lists->Commas->Place comas before items-> Comma alignment -> "to statement". I've created a ticket in our internal track system SP-6849 to handle it.

We will get back to you when it is fixed.

Best regards,
Krzysztof