Competition: What’s your favorite Redgate tool? Enter now.

JOIN Layout Suggestion

pburlesonpburleson Posts: 12
edited March 27, 2009 5:14AM in SQL Prompt Previous Versions
We've been looking at using SQL Prompt 3 to apply a consistent layout to our SQL Code and after working with our team, we have a suggestion. Within the Data Statements, for JOINS, allow having the ( on the next line not be indented. Also, we'd like to have the ON on the line with the join and the start of the clauses on the next like.

For example, here's how SQL Prompt would do it now:

SELECT
staffId,
staffName,
a
FROM
personnel
INNER JOIN (
SELECT
a
FROM
b
) AS ab
ON personnel.a = ab.a

Here's what we'd like:

SELECT
staffId,
staffName,
a
FROM
personnel
INNER JOIN
(
SELECT
a
FROM
b
) AS ab ON
personnel.a = ab.a

The ON with the new line is less important than having the sub query not indent an extra time.

Thanks,
Patrick

Comments

  • Thanks for your forum post. I have logged your layout request in our tracking system. I have placed a watch on this issue so that I am informed if/when the status changes. It will be considered for a future release of SQL Prompt although I cannot guarantee if/when it will make it in.
Sign In or Register to comment.