SQL Prompt adding Quotes at end of list not around criteria and won't add commas

NKeith

If I have this  ('100' '103' '104' '172' '174') --- (Note No Commas and I am using SQL Server)

and select Add quotes, nothing happens and if I select "add quotes and commas"  I get this-- '(''100'' ''103'' ''104'' ''172'' ''174'')'I need it to  do this ( '100', '103' , '104', '172', '174' )  why did it stop doing this formatting and how can I fix it?  UPDATE -  A coworker said this happened to him as well and he thinks it is something to do with when we copy and paste from excel -  where it basically wraps lines in quotes. How can we correct this?

squigley

Good Afternoon!

Thanks for your inquiry and sorry to hear about your issue with SQL Prompt.

Can you confirm what version of SQL Prompt and SQL Server that this involves? I want to see if I can replicate this on my end.

NKeith

I am using SQL Server 2016 version 13.0.16000.28  and SQL Prompt version 9.4.7.7595

squigley

Good Afternoon,

Thanks for sending those details regarding the versions involved.

Can you confirm that you encounter the same issue if you upgrade to the latest version of SQL Prompt?

Download Link: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.3.7.15732.exe

Upgrade Documentation: https://documentation.red-gate.com/sp/upgrading

The reason why I ask to try upgrading is that the version you're using is from almost two years ago and the developers are not likely to fix the issue unless it also occurs on the latest versions of the tool as well.

Thanks!