How to put the OPTION clause on a separate line?

ogrishman

Hi guys,

I have the following query:

SELECT
    p.Name,
    Total = SUM(inv.Quantity)
  FROM
    Production.Product AS p
    INNER JOIN Production.ProductInventory AS inv
        ON inv.ProductID = p.ProductID
 WHERE p.Name LIKE N'[A-G]%'
 GROUP BY p.Name OPTION(RECOMPILE, QUERYTRACEON 8605);

Is it possible to format it and put OPTION clause on a separate line? I tried but can't find an option to control this behavior. Is it possible?

Thanks.

Aaron L

Hi ogrishman,

Thanks for your post! In the 7.3 beta formatter there's currently no setting to put the OPTION clause on a new line. We'll look into improving this and I'll let you know when we have a new build out with it in.

Thanks,
Aaron.