How can we help you today? How can we help you today?
Ali D
Activity overview Badges (0) Posts (0) Comments (56)

Comments

Sort by recent activity
Hi opc.three This issue should now be fixed in the latest beta (7.1.0.234): https://forums.red-gate.com/viewtopic.php?f=169&t=78967 Please let us know if you have any issues with this build. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Error formatting MERGE statement in WHEN NOT MATCHED BY
Hi opc.three This issue should now be fixed in the latest beta (7.1.0.234): https://forums.red-gate.com/viewtopic.php?f=169&t=78967 Please let us know if you have any issues with this build. Thanks...
0 votes
Hi opc.three Sorry for the confusion, we think we’ve now been able to reproduce this issue and we’ll look into improving this. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Error formatting MERGE statement in WHEN NOT MATCHED BY
Hi opc.three Sorry for the confusion, we think we’ve now been able to reproduce this issue and we’ll look into improving this. Thanks Ali
0 votes
Hi vsha041 I’m sorry to hear that you’re having trouble with this feature. I’ve tried to reproduce the issue on an identical set up to yours but the problem isn’t occurring for me. There are a few things that could be going on here: Just to check before we go any further, is the caret inside the block you want to execute before you press Shift+F5? (see this video for more information: https://youtu.be/BqHZ4wqh_Ko?t=40 ). It’s possible that something else has bound to this keyboard shortcut. To find out whether this is the case, inside SSMS go to Tools > Options > Keyboard and filter the commands list by ‘ExecuteCurrentStatement’. Is the shortcut for the 'RedGate.SQLPrompt.SSMSUI.Connect2011.ExecuteCurrentStatement' command ‘Shift+F5 (SQL Query Editor)' ? If the shortcut is different you can manually change this shortcut back to Shift+F5 which should fix the problem. After restarting SSMS, the shortcut may revert to whatever had stolen it in the first place. If this is the case then we can make a configuration change to force SQL Prompt to rebind its shortcuts on start up. If the shortcut in the Options window is not different then can you see the 'Shift+F5' key binding list next the context menu item for Execute Current Statement when you right click on a statement? Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt Shift + F5 Issue
Hi vsha041 I’m sorry to hear that you’re having trouble with this feature. I’ve tried to reproduce the issue on an identical set up to yours but the problem isn’t occurring for me. There ar...
0 votes
Hi Aaron If the network folder is unavailable when SQL Prompt starts up then it will revert to using its default snippets folder. We've had a few customers successfully share their snippets in a source controlled location, like a Git or Mercurial repository. Another option is to store your snippets folder in a synchronised location, such as a Dropbox or OneDrive folder. These may be better solutions if your network share is not consistently available. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Snippet Repository resetting to default
Hi Aaron If the network folder is unavailable when SQL Prompt starts up then it will revert to using its default snippets folder. We've had a few customers successfully share their snippets in a so...
0 votes
Thanks for all your help with this - it's now fixed in the latest beta. / comments
  1. Community
  2. SQL Prompt
  3. Open in Excel (7.1.0.118)
Thanks for all your help with this - it's now fixed in the latest beta.
0 votes
Hi Jim Glad to hear you're using the export feature already. You're right, the SQL datetimes are getting exported into Excel as strings. It is possible to format these cells in bulk without having to click inside each one: 1. In Excel, set that column's data type to "Date" (highlight, right click > Format Cells... > select Date in the Category list). 2. With these cells still highlighted, go to DATA (in the ribbon) > Text to Columns > Finish. Configuring your preferred date time format and then exporting to Excel as that data type is a reasonably large piece of work. If you'd like to see this functionality in SQL Prompt then please submit a UserVoice request here. This will help us gauge interest and prioritise the work. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Open in Excel (7.1.0.118)
Hi Jim Glad to hear you're using the export feature already. You're right, the SQL datetimes are getting exported into Excel as strings. It is possible to format these cells in bulk without having ...
0 votes
Hi Jim I spent a few hours looking into exporting datetimes directly into Excel. Unfortunately, Excel only has separate date and time column types with no native analogue of a SQL datetime object. Setting a column's type to a string or number is very simple, creating a custom cell format to display a datetime is more complex, especially when programmatically generating the Excel file from code. If you create a UserVoice request for this alongside your original request, we will look at this again if it a lot of people are having the same problem. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Open in Excel (7.1.0.118)
Hi Jim I spent a few hours looking into exporting datetimes directly into Excel. Unfortunately, Excel only has separate date and time column types with no native analogue of a SQL datetime object. ...
0 votes
Hi Thanks for your suggestion. We currently have a Uservoice forum for feature requests which is the best place to post this idea. It’ll allow other users that are interested to vote on it and helps us prioritise which feature to work on next (and you’ll get notified of any progress on it). I had a quick search and there are a couple of related ideas that you might be interested in: https://redgate.uservoice.com/forums/94 ... ening-file https://redgate.uservoice.com/forums/94 ... y-of-files Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. Format all open SQL files with a single command
Hi Thanks for your suggestion. We currently have a Uservoice forum for feature requests which is the best place to post this idea. It’ll allow other users that are interested to vote on it and he...
0 votes
We’ve just released a new version (v7.2.2) which fixes this issue. If you’ve still got the original (and incorrect) ‘curff’ snippet then it will be updated to the corrected snippet. If you’ve already modified the ‘curff’ snippet in any way then it will not overwrite your changes. New installations of SQL Prompt will use the corrected snippet. You can get the latest build by using Check for Updates or by downloading it from here. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. bug in cuff snippet
We’ve just released a new version (v7.2.2) which fixes this issue. If you’ve still got the original (and incorrect) ‘curff’ snippet then it will be updated to the corrected snippet. If youâ...
0 votes
Hi Thanks for letting us know this is still an issue. We made the fix when the issue was first reported but this change was overwritten during the subsequent overhaul of the snippets manager. We’ll fix the default snippet again and it’ll be in the next release. Thanks Ali / comments
  1. Community
  2. SQL Prompt
  3. bug in cuff snippet
Hi Thanks for letting us know this is still an issue. We made the fix when the issue was first reported but this change was overwritten during the subsequent overhaul of the snippets manager. We’...
0 votes
Total activity
91
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
35