Devart Forums

Posted: **Thu 02 Jun 2011 17:36**

I generally write statements using a bit of indenting, but I haven't figured out how to get the formatting to the way I generally write selects. I use the following:

Code: Select all

SELECT
    Field1,
    CASE
        WHEN Field2 = 1 THEN 'Yes'
        ELSE 'No'
    END AS YesNo
FROM
    Table1 t1
        INNER JOIN a_Table2 ON
            t1.Table2Id = t2.Table2Id

Posted: **Fri 03 Jun 2011 10:33**

Unfortunately, it is impossible to setup such formatting in the current version of dbForge SQL Complete, but we planned implementing several additional options in one of the next versions of SQL Complete, and these options will help you to obtain the needed formatting.

Posted: **Fri 03 Jun 2011 12:15**

Thanks for the quick reply. I'm looking forward to the update, but I remain very happy with what you've already put together.

Devart Forums

Formatting Options

Formatting Options