SQL Pretty Printer: beautify the messy sql code instantly!

At MMS 2009, during "SQL Performance Tips for SMS and ConfigMgr Reporting Gurus" session by Brian Mason and Steve Thompson, this neat tool was featured and bought to the worlds attention (or those that never knew about it).

This tool will even make John Nelson aka #2 happy so he doesnt have to see any ugly formatted SQL code (I will update the exact quote from Brian Mason shortly, lol)

SQL Pretty Printer is available from here @ wangz.net current cost is $39.95 with a 15 day money back guarantee, also see here to see if you qualify for a free licence

SQL Pretty Printer is a tool that will help you beautify your SQL code. Using hotkey functionality, SQL Pretty Printer can reformat SQL statements for a wide variety of database tools such as Microsoft Query Analyzer, SQL Server Management Studio (SSMS), TOAD and PL/SQL Developer, development environments such as Visual Studio 2003/2005 and Eclipse, and popular editors such as UltraEditor and EditPlus.

In addition to beautifying SQL code, SQL Pretty Printer can translate SQL code into C#, Java, PHP, DELPHI and other program languages.

SQL Pretty Printer also includes command line functionality, with the ability to format single files, single directories and multiple directories.

One thing to note is: This Add-In works in SQL Server Management Studio(SSMS), with .NET2.0 installed. It doesn't work for EE edition of SSMS

You can also try an online demo version of this tool here

SQL code before being beautified

SQL code after being beautified