SqlDbx
You are not logged in.
Hello
Im using the following settings in SQL Formatter.
Line Breaks
- Before comma
- Before AND/OR
- After (SELECT ...)
Block Style
- Style 1
Spaces | Operators
- A = B + C
Spaces | Lists
- A, B, C
Spaces | Braces
- count(A)
But this doest not work anymore since about one year.
Original SQL
SELECT v100.aufnr FROM v100 WHERE v100.vvorgart = 2 AND v100.fi_nr = 1 AND v100.datneu < getdate () -100 AND (v100.datbis < getdate () -10 OR v100.datbis IS NULL) AND v100.ang_stat = 20
Result with SQL Formatter
SELECT
v100.aufnr
FROM
v100
WHERE
v100.vvorgart = 2 AND v100.fi_nr = 1 AND v100.datneu < getdate () -100 AND (v100.datbis < getdate () -10 OR v100.datbis IS NULL) AND v100.ang_stat = 20
Expected Result
SELECT
v100.aufnr
FROM
v100
WHERE
v100.vvorgart = 2
AND v100.fi_nr = 1
AND v100.datneu < getdate () -100
AND (v100.datbis < getdate () -10 OR v100.datbis IS NULL)
AND v100.ang_stat = 20
Thank you for your support.
DaMuchi
Offline