format error

torsten.strauss

Hi Redgate Team,

SQL Prompt will report an error when trying to format the following statement

CREATE NONCLUSTERED COLUMNSTORE INDEX [NCLCSI_product_price_latest_ID_product_price_latest] ON [products].[product_price_latest]

(

[ID_product_price_latest]

)

WHERE ([ID_site_to_product]=(-1))

WITH (DROP_EXISTING = OFF, COMPRESSION_DELAY = 0) ON [Data]

GO

Thanks for fixing it!
Torsten

squigley

Hello Torsten,

Thanks for your inquiry and sorry to hear about your issue with the SQL Prompt tool.
I can confirm that I also getting a formatting error on my end, I'll be sure to escalate this appropriately and let you know of our next steps.

Thanks!

squigley

Hello Torsten,

Thank you for your patience with this.
I can happily confirm from the developers that your issue should now be fixed in the latest version which you can grab here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.5.6.17542.exe

Please let me know if the fix works on your end.

Thanks!