Love the product, but am coming from the SSMS / SQL Prompt (RedGate) area. I can't seem to get the SQL formatting to behave consistently no matter what I do.
I've tried all kinds of combinations and options - except for the bizarre indentations happening the remaining SQL formatting is to my liking. But I just can't figure this out.
This is a new stored proc snippet for MSSQL:
1. the set nocount on is oddly indented - can't find any solution for that.
2. After my declarations are done, the next if statement and (3) create temp table are indented.
4. Suddenly, the insert into statement is not indented, as it should be.
5. Back to indentation for some reason?
6. Indentation continues...