Formatting style - BUG (case when)

NatanD

There seems to be a bug when formatting the following code:

<div>DECLARE @date datetime = NULL</div><div>SELECT @date = CASE WHEN @date IS NULL THEN GETDATE()ELSE @date END</div>

In this case there is a problem with spaces,
and it seems that the Formatter does not refer to settings, such as a new line etc.

DustinM

Hello,

Thank you for your inquiry into SQL Prompt, we are sorry to hear it is giving you trouble.

Would you be able to tell us which version of SQL prompt you are currently using?

Regarding the sample query provided are you keeping the <div></div> in place while attempting to format? Would you also be able to provide a screenshot of the output when formatting?

Best,

Dustin