Comments
Sort by recent activity
Ok, so, sort of - I have that one set to 180 turning it off sorts that FOR statement, but also this: [image] [image] [image] becomes: [image] So it seems like there is no way to balance having both The closest from here seems to be if I change List items from always to if longer than wrap column [image] [image] however other statements like: [image] become [image] Which is sort of the reverse of what I am going for with those ones lol. I will have to keep playing. / comments
Ok, so, sort of - I have that one set to 180turning it off sorts that FOR statement, but also this:becomes:So it seems like there is no way to balance having bothThe closest from here seems to be i...
sure.. I mean this is just an extract with some begins and the like to show you the indentation effects applied upon a CTRL+K+Y - there's obviously more to the procs we use but it happens in all circumstances and this should suffice to demonstrate the issue - screenshot attached as well. <br><div>BEGIN</div><div>BEGIN TRY</div><div>IF 1 = 1</div><div>BEGIN</div><div>SELECT [ValuationDate] = [Date],</div><div> FulcrumEntityId,</div><div> Parent_Portfolio,</div><div> Parent_PortfolioId,</div><div> [TotalFundValue] = [Total Fund Value],</div><div> [AggregatesValue] = [Aggregates],</div><div> AggregatesVsTotalFundPercent = [Aggregates] / NULLIF([Total Fund Value], 0)</div><div> INTO #tblPivot</div><div> FROM (SELECT FulcrumEntityId, Parent_Portfolio, Parent_PortfolioId, PortfolioType, [Date], Valuation FROM #tblAggregateValue) UFV</div><div> PIVOT (SUM(Valuation)</div><div>FOR PortfolioType IN ([Total Fund Value], [Aggregates])) PivotData;</div><div>END;</div><div>END TRY</div><div>BEGIN CATCH</div><div>PRINT 'Error';</div><div>END CATCH;</div><div>END;</div><div><br></div>
[image] [image]
/ comments
sure.. I mean this is just an extract with some begins and the like to show you the indentation effects applied upon a CTRL+K+Y - there's obviously more to the procs we use but it happens in all c...
Just wanted to confirm: 10.14.4.4865 works It took me refreshing a few times, both the connection and the suggestions, but they populated after that - and yes, I tried this on the other versions too but without much avail. Hopefully Redgate get this resolved in their next release. / comments
Just wanted to confirm: 10.14.4.4865 worksIt took me refreshing a few times, both the connection and the suggestions, but they populated after that - and yes, I tried this on the other versions too...
@hassan_imam - I haven't tried the latest version - this post a from ben at the bottom of this thread seems to indicate there is still an issue that hasn't been resolved though: https://forum.red-gate.com/discussion/90375/anyone-else-have-suggestions-not-working-in-latest-update-of-sql-prompt I don't have the time to update and test right now, because if it doesn't work there isn't a "downgrade" option, you have to uninstall and reinstall and believe it or not, I am up against the wall at the moment. / comments
@hassan_imam - I haven't tried the latest version - this post a from ben at the bottom of this thread seems to indicate there is still an issue that hasn't been resolved though: https://forum.red-g...
Hey, thanks for getting back to me, Just FYI
10.14.6.5992 - Released on 24 January 2024 Still doesn't work with PaaS Going to try downgrading like you suggest now. / comments
Hey, thanks for getting back to me, Just FYI
10.14.6.5992 - Released on 24 January 2024Still doesn't work with PaaSGoing to try downgrading like you suggest now.
Ben_P said:
The issue seems to be due to SSMS 19.3 using MDS 3.1.5 whilst SQL Prompt uses 3.1.1. Whilst the team work on a solution for this, it is recommended to use an earlier version of SSMS, such as 19.2 or 18.12.1. Users have also reported that downgrading SQL Prompt to 10.4.4 has worked for them: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.4.4865.exe
Hi Ben - what's the solution for the latest issue where the column picker etc stopped working randomly and upgrading has not hellped? / comments
Ben_P said:
The issue seems to be due to SSMS 19.3 using MDS 3.1.5 whilst SQL Prompt uses 3.1.1. Whilst the team work on a solution for this, it is recommended to use an earlier version of SS...
Nikolai_Sklobovsky said:
Went several version back down to May 1st. Same stuff. Intellisense suggestions don't work... [image]
Hi, yes, Redgate had been nagging me to update for ages but i didn't want to due to the issues with intellisense not working. I hadn't upgraded SSMS or Redgatge and intellisense stopped working anyway... So I upgraded redgate, no joy, upgraded SSMS, still not working. Formatting still works but the column picker etc is where I get most of my Gains. Frustrating to be back here... again. / comments
Nikolai_Sklobovsky said:
Went several version back down to May 1st. Same stuff. Intellisense suggestions don't work...
Hi, yes, Redgate had been nagging me to update for ages but i didn't ...
Hey Ben, I think it is also the AAD (Azure active directory - Integrated) version [image] [image] / comments
Hey Ben, I think it is also the AAD (Azure active directory - Integrated) version
Just to confirm - the latest 2 editions for SQL prompt do not work, the downgrade to SQL prompt 10.14.4.4865 gets things working again though. / comments
Just to confirm - the latest 2 editions for SQL prompt do not work, the downgrade to SQL prompt 10.14.4.4865 gets things working again though.
You're not the only one, all our PaaS connections do not work in the latest version though our IaaS connections do - but our IaaS connections use windows auth and our PaaS use Microsoft Entra MFA / comments
You're not the only one, all our PaaS connections do not work in the latest version though our IaaS connections do - but our IaaS connections use windows auth and our PaaS use Microsoft Entra MFA