Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Formatting adds unneeded spaces

edited January 11, 2017 8:46AM in SQL Prompt

The formatting seems to add additional spaces after the last SELECT and WHERE which are unneeded.
Would be nice to get this sorted -thanks!

--get the transactions covered by the active CFPs
DECLARE @lower_bound_tsn bigint ;
DECLARE @upper_bound_tsn bigint ;
@lower_bound_tsn = MIN(xcf.lower_bound_tsn)
, @upper_bound_tsn = MAX(xcf.upper_bound_tsn)
FROM sys.dm_db_xtp_checkpoint_files AS xcf
xcf.file_type = 2
AND xcf.state = 2 ;
SELECT * FROM sys.fn_dblog_xtp(NULL, NULL) WHERE tx_end_timestamp BETWEEN @lower_bound_tsn AND @upper_bound_tsn ;


Sign In or Register to comment.