Hanging while formatting T-SQL statement

[PerryCodes]

The following sql query is causing SQL Transformer to become unresponsive after running 'SQL Transformer: Format SQL' on this Transact-SQL statement for MS SQL Server:

SELECT m.MeterID,
       m.EMRID,
       m.MXUID,
       m.Latitude,
       m.Longitude,
       l.LocationNumber,
       l.ServiceAddress,
       X.Cycle,
       X.CustomerNumber
FROM (
       SELECT b.ID,
              tblMeterID,
              tblCustomerID,
              c.CustomerNumber,
              RIGHT('00' + CAST(c.Cycle AS varchar(2)), 2) AS Cycle,
              row_number() OVER (
                     PARTITION BY tblMeterID
                     ORDER BY b.ConnectDate DESC,
                              c.IsLandlord ASC
                     ) AS r
       FROM tblBilling b
       JOIN tblCustomer c ON c.ID = b.tblCustomerID
       WHERE tblMeterID IS NOT NULL
         AND FinalDisconnectDate IS NULL
       ) AS X
JOIN tblMeter m ON X.tblMeterID = m.ID
JOIN tblLocation l ON m.tblLocationID = l.ID
WHERE r = 1
  AND m.StatusCode = 'Active'
  AND (m.EMRID <> '' OR m.EMRID IS NULL)
ORDER BY m.MeterID

[roobyz]

hi @PerryCodes

I formatted your code successfully without issue. Are you running the latest version of VSCode and the extension? Anything else you could add that my help me discover your issue?

BTW, this is the outcome:

     SELECT m.MeterID
          , m.EMRID
          , m.MXUID
          , m.Latitude
          , m.Longitude
          , l.LocationNumber
          , l.ServiceAddress
          , X.Cycle
          , X.CustomerNumber
       FROM (SELECT b.ID
                  , tblMeterID
                  , tblCustomerID
                  , c.CustomerNumber
                  , RIGHT('00' + CAST(c.Cycle AS varchar (2)), 2) AS Cycle
                  , row_number() OVER (PARTITION BY tblMeterID
                                      ORDER BY b.ConnectDate DESC
                                             , c.IsLandlord ASC) AS r
               FROM tblBilling b
               JOIN tblCustomer c
                 ON c.ID = b.tblCustomerID
              WHERE 1=1
                AND tblMeterID IS NOT NULL
                AND FinalDisconnectDate IS NULL) AS X
       JOIN tblMeter m
         ON X.tblMeterID = m.ID
       JOIN tblLocation l
         ON m.tblLocationID = l.ID
      WHERE 1=1
        AND r = 1
        AND m.StatusCode = 'Active'
        AND(m.EMRID <> ''
         OR m.EMRID IS NULL)
   ORDER BY m.MeterID
;

Roberto