format sql adding spaces in fully qualified names

WeeeBob

Hi

just a moan rather than anything. But I'm finding that SQL refactor is inserting spaces in some of my references. seems to be only in sub queries, that go over different databases. Is there any settings i can change to prevent this, I can't see any?

eg. This is what the code looks like after applying my sql layout. Note the spaces in the subquery reference to the 'LoadingDate' table

--CashflowRec total and average
SELECT
    COUNT(*) TotNewReportCashFlowsRec ,
    (
     SELECT
        AVG(t.tc)
     FROM
        (
         SELECT
            COUNT(*) AS tc
         FROM
            MRS_warehouse.DataReader.Report_StatusCashFlowsRec
         WHERE
            SystemLoadingDate<>(
                                SELECT SystemLoadingDate FROM MRS_Staging . dbo . LoadingDate
                               )
         GROUP BY
            SystemloadingDate
        ) AS t
    ) AS AverageTotNewReportCashFlowsRec
FROM
    DataReader.Report_StatusCashFlowsRec
WHERE
    SystemLoadingDate=(
                       SELECT SystemLoadingDate FROM MRS_Staging . dbo . LoadingDate
                      )

JonathanWatts

Hi there WeeeBob,

Thanks for bring this to our attention, we hope to fix this in the next release of SQL Refactor.

Regards,

Jonathan