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

alphonseg

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.

krzysztofkroczak

Hi @alphonseg,

Can you provide us with your style?

Best regards,
Krzysztof

alphonseg

Attached

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