Hi,
I am having problems with the analytical functions/window queries formatting.
for a statement like this
SELECT a.COL1 AS COL1 , a.COL2 AS COL2 , RANK() OVER (PARTITION BY a.COL1 ORDER BY a.COL3 ASC) AS COL3 , FIRST_VALUR() OVER (PARTITION BY a.COL2 ORDER BY a.COL3 ASC) AS COL4 , LEAD() OVER (PARTITION BY a.COL2 ORDER BY a.COL3 ASC) AS COL5 FROM db.schm.tbl a ;
I am unable to get the formatting right (as its formatted now is how I would ideally like it)
However at the moment I can't seem to effect any changes, it always comes out like this
, RANK() OVER
(
PARTITION BY a.COL1 ORDER BY a.COL3 ASC
)
AS COL3
with a line break before and after the opening/closing bracket
I only recently upgraded my version, and I don't believe this was an issue with the version I was previously using (unfortunately I don't have the machine it was installed on anymore to double check)
and I am not sure if that's was default settings or I just liked how it looked out of the box.
Current version: 6.25.1.29 (Desktop)
Am I missing a setting somewhere?
If not is it possible to add in formatting options analytical functions please?
** extra unrelated note, I believe the tool tip for [ SP-> Parms -> Before ")" ] may be incorrect as it reads with an "="



