How can we help you today? How can we help you today?

How to put the OPTION clause on a separate line?

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.
ogrishman
0

Comments

1 comment

Sort by
  • 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.
    Aaron L
    0

Add comment

Please sign in to leave a comment.