Competition: What’s your favorite Redgate tool? Enter now.

Formatting adds unneeded spaces

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

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 ;
SELECT
@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
WHERE
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 ;

Comments

Sign In or Register to comment.