SQL Prompt - V10.6.16.21150 - SELECT TOP 100

Robin_D

Hey
In an older version of SQL Prompt I could write
SELECT TOP 100 Col1, Col2, Col3
FROM
But in this version it is
SELECT TOP 100
               Col1, Col2 Col3

What option(s) do I need so the column list is on the same as TOP 100. If I remove TOP 100 it works. I've tried an everything seems to be set to Never for moving to a new line
Thanks

Dan_J

Hey @Robin_D

Thanks for reaching out regarding this.

If you deselect 'Add new line after DISTINCT / TOP clause' under the 'Data (DML)' options you should be able to achieve the formatting you are after.

I hope this helps!

Dan_J

Hi @Robin_D

I just wanted to check if you require any further assistance with this?