IIF

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

Answers

  • 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
Sign In or Register to comment.