Home Forums SQL Server 2008 SQL Server 2008 - General Another free T-SQL Formatter, open-source and SQL2K8-compatible, SSMS Add-In RE: Another free T-SQL Formatter, open-source and SQL2K8-compatible, SSMS Add-In

  • Thanks for the feedback gvarol!

    #1: I think you can just uncheck the "Expand Comma Lists" option, or am I missing something? If you want to wrap based on a specific line width, you can also set the "Max Width" option to a more sensible value - the 999 default is just to keep it out of the way.

    #2: It's definitely by design that subqueries and derived tables are always indented... Are you saying that you'd want the whole thing on one line, or that you would just want the "SELECT OutVal" portion on the same line as the "CAST((", and wrapping afterwards?

    #3: Looks like a bug, I'll definitely look into it!

    #4: Removing most of those newlines is just a question of unchecking the "Expand Comma Lists" option; the one that you won't be able to remove is the one just before OPTION - I'm always breaking the OPTION clause out. You're saying that you'd like the whole thing to appear on a single line?? Or am I misunderstanding something?

    http://poorsql.com for T-SQL formatting: free as in speech, free as in beer, free to run in SSMS or on your version control server - free however you want it.