Hi Redgate Team,
SQL prompt adds tabs between the ORDER BY which is not my intention:
WITH c
AS
(
SELECT
LAG(cntr_timestamp, 1) OVER ( PARTITION BY counter_name ORDER BY
cntr_timestamp
) AS lag_cntr_timestamp
, cntr_timestamp
, object_name
, counter_name
, instance_name
, cntr_value
, LAG(cntr_value, 1) OVER ( PARTITION BY counter_name ORDER BY
cntr_timestamp
) AS lag_cntr_value
, cntr_value
- LAG(cntr_value, 1) OVER ( PARTITION BY counter_name ORDER BY
cntr_timestamp
) AS delta_cntr_value
, ( 100.0
/ NULLIF(( LAG(cntr_value, 1) OVER ( PARTITION BY counter_name ORDER BY
-- a lot tabs !!!
cntr_timestamp
)
), 0)
)
* cntr_value AS delta_pct_cntr_value
FROM performance_counters
)
SELECT
object_name
, counter_name
, instance_name
, cntr_value
, lag_cntr_value
, delta_cntr_value
, delta_pct_cntr_value
FROM c
WHERE
delta_cntr_value <> 0
AND c.object_name = N'MSSQL$MYSQLSERVER2017:Databases'
GO
Would be nice to get rid of these tabs - thanks!
Regards
Torsten
Version 9.1.1.4243
Hi @....strauss,
SQL prompt adds tabs between the ORDER BY which is not my intention:
Would be nice to get rid of these tabs - thanks!
Regards
Torsten
Version 9.1.1.4243