We use a tool from from Red Gate software called SQL Formatter that works fantastic for doing exactly what you want.
However.....I think it's expensive. On Thu, Apr 1, 2010 at 3:19 AM, Matthew Smith <chedders...@gmail.com> wrote: > > I'm working on a rather complicated stored procedure. Lots of nesting with > if's and such. > > Are there better tools to edit sql code? something that will show me where > I am in nested code and handle the formatting? > > Thank you. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:314750 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-community/unsubscribe.cfm