Temp table name replacement

• 
  Hi,
  
  Sorry to hear you're having issues with SQL Prompt. This issue seems quite unusual - would you be able to give us a bit more information so we can work out what's going on?
  
  Thanks,
  
  Tom
  

  TomW July 22, 2019 08:28

  - 0 +
• 
  Hi Tom,
  
  Thanks for coming back on this.
  
  I have a series of scripts that I'm working on, and have created a format rule set based on our company's standards. I open one of the files to work on, and select Format SQL (or Ctrl K, Ctrl Y) and the formatting begins. I have the editor open showing the line in question and can watch the process remove the temp table #EligibleItems and replace it with [databaselimitedname] text.
  
  I am running the following:
  
  Environment: Azure VM running Windows Server 2016
  SQL MS: SQL Server Management Studio v17.9.1
  SQL Server: MS SQL 2017 Developer Edition 64-bit
  SQL Prompt:Updated this morning to 9.5.12.10845
  
  Sample of specific code:
  
  SELECT...
  INTO #EligibleItems EligibleItems <---------------------- This is the line that experiences the issue
  FROM #EligibleItemItds ETSET
  INNER JOIN
  Base.FinalDebit FD WITH (SNAPSHOT)
  ON
  ETSET.TransactionSetId = FD.TransactionSetId
  
  Screenshots:
  
  Before:
  
  
  
  After:
  
  
  
  Thanks again Tom - any further info required just let me know.
  
  Best regards,
  Steve

  SteveC1971 July 22, 2019 09:50

  - 0 +
• 
  Hi Steve,
  
  That's indeed very odd. Would you be able to share the format file and the complete script with us?

  Tianjiao_Li July 22, 2019 14:45

  - 0 +
• 
  Hi,
  
  Thanks again for the help - I've spotted the issue: an alias has made its way to the INTO line; absolutely not allowed of course, why would you?! Removing that solves the problem.
  
  Apologies for wasting your time.
  
  Best regards,
  Steve

  SteveC1971 July 22, 2019 16:05

  - 0 +

Add comment

Please sign in to leave a comment.