Activity overview
Latest activity by SteveC1971
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 / comments
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 w...
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: [image] After: [image] Thanks again Tom - any further info required just let me know. Best regards, Steve / comments
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 se...
Temp table name replacement
Hi,Trialling SQL Prompt and have noticed the following:When formatting code that includes a SELECT...INTO #Table section, the formatting will replace the #Table with [[databaselimitedname]]]Any ide...