Getting error while formatting SQL code.

• 
  Any update here?

  jay2807 January 27, 2021 20:21

  - 0 +
• 
  Hi @jay2807
  

  
  

  My sincere apology for the delay in responding to you on this.

  
  

  It would be good to see a copy of your stored procedure if possible. We have raised a support ticket for this issue and I will contact you through that going forward.
  

  
  

  Dan_J February 03, 2021 13:44

  - 0 +
• 
  Hi, @Dan_J
  
  I have attached stored procedure in the question.

  jay2807 February 06, 2021 18:55

  - 0 +
• 
  Hello, @Dan_J, Any update?

  jay2807 February 23, 2021 20:46

  - 0 +
• 
  Hi @jay2807
  

  
  

  My sincerest apology, I hadn't spotted your updates on this before now! Thanks very much for confirming that you have provided your stored procedure.
  

  
  

  I have been able to replicate the issue you are seeing, and I will very shortly be discussing this with my colleagues. In the mean time, please can you confirm which version of SQL Prompt you are currently using?
  

  Dan_J March 18, 2021 14:57

  - 0 +
• 
  Hi @jay2807
  

  
  

  Just to update you on this, our development team have taken this on and will be working on it. I will update you again on this as soon as I hear anything from them.
  

  
  

  Dan_J March 19, 2021 16:46

  - 0 +
• 
  @Dan_J, I'm using SQL Prompt Version 10.6.5.18584

  jay2807 March 19, 2021 17:11

  - 0 +
• 
  Hi @jay2807
  

  
  

  Our development team have taken a look at this. It appears there is a bug in the Microsoft parser, and so they have logged this with Microsoft. Unfortunately we are at the mercy of if/when Microsoft chose to fix this.
  

  
  

  Again, I will update you on this as soon as I have more information.
  

  Dan_J March 25, 2021 10:41

  - 0 +
• 
  Hi @Dan_J, Any updates?
  

  jay2807 April 06, 2021 18:24

  - 0 +
• 
  Hello, @Dan_J, Any update?
  

  jay2807 April 08, 2021 19:26

  - 0 +
• 
  Hi @jay2807!

  
  

  I am so sorry for the delayed reply to you on this! There appears to have been some confusion at this end, around working on a fix for this issue/bug.
  

  
  

  Given the nature of this bug, unfortunately we are essentially unable to work on a fix for this ourselves until  Microsoft have released a fix also. While we can't say when they are likely to work on this, we don't see it being within the next 6-12 months.

  
  

  We do appreciate that this is not ideal for you, or anyone else who may be experiencing this issue, and so we will continue to press Microsoft for a solution to this. We have also logged a ticket for this and will keep it on hold for our visibility.
  

  Dan_J April 16, 2021 12:57

  - 0 +
• 
  @Dan_J, Can you post the ticket link here in the comment that you logged to Microsoft, please?
  

  jay2807 April 20, 2021 16:26

  - 0 +
• 
  Hi @jay2807
  

  
  

  Sure, the link to the ticket is: https://github.com/microsoft/sqltoolsservice/issues/1181

  
  
  

  Dan_J April 22, 2021 08:39

  - 0 +

Add comment

Please sign in to leave a comment.