Comments
Sort by recent activity
Hello chrisk5,
I get the same result. The following SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C --Child
ON P.NAME = C.Parent
still is formated to this SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C
--Child
ON
P.NAME = C.Parent
with the imported style you provided.
Edmund / comments
Hello chrisk5,
I get the same result. The followingSELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C --Child
ON P.NAME = C.Parent
still is fo...
Hi chrisk5,
Things format a little better with the recomendation you provided. The following
SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C --Child
ON P.NAME = C.Parent
now formats to
SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C --Child
ON P.NAME = C.Parent
.
The commet stays on the same line but ON condition is indented. However, I can't use that option as I need the join condition on a new line in locations where there is no table alias comment and the join condition is currently on the same line.
I guess the good news is that this is a known issue. As I understand this thread there is no fix for this currently but it will be addressed in the next update of SQL Prompt. Correct?
Thanks,
Edmund / comments
Hi chrisk5,
Things format a little better with the recomendation you provided. The following
SELECT P.NAME AS Parent, C.NAME AS Child
FROM dbo.ListOfThings P --Parent
JOIN dbo.ListOfThings C -...
SSMS: 10.50.1600.1
SQL Prompt Pro: 5.1.4.11 / comments
SSMS: 10.50.1600.1
SQL Prompt Pro: 5.1.4.11