How can we help you today? How can we help you today?

Parenthesis Style does not work when Join Keyword is not on new line

SQL Prompt is simply great and I'm depending on it more and more. However, that means that quirks become more annoying.
When 'Place Join keyword on new line' is UN-checked and the Parentheses style is set to far left, the parentheses is aligned with the Join keyword and not placed on the far left. 
SELECT
	AU.UserName
FROM
	dbo.aspnet_Users AS AU INNER JOIN
								  (
									  SELECT
											AUIR.UserId
									  FROM
											dbo.aspnet_UsersInRoles AS AUIR
									  GROUP BY
										  AUIR.UserId
									  HAVING
											COUNT(*) > 1
								  ) AS RC ON AU.UserId = RC.UserId;
Should be: 
SELECT
	AU.UserName
FROM
	dbo.aspnet_Users AS AU INNER JOIN
	(
		SELECT
			AUIR.UserId
		FROM
			dbo.aspnet_UsersInRoles AS AUIR
		GROUP BY
			AUIR.UserId
		HAVING
			COUNT(*) > 1
	) AS RC ON AU.UserId = RC.UserId;
Any chance of fixing this.
alphonseg
0

Comments

3 comments

Sort by
  • krzysztofkroczak
    Hi @alphonseg,

    Can you provide us with your style?

    Best regards,
    Krzysztof
    krzysztofkroczak
    0
  • alphonseg
    Attached
    alphonseg
    0
  • RichardL
    Hi @alphonseg

    Thanks for your post. 

    I see that you may have a support contract. Could you please send us a ticket. Provide as much information as you can - screenshots of any errors, log files etc – so we can help you as fast as possible. 

    Kind regards
    RichardL
    0

Add comment

Please sign in to leave a comment.