Activity overview
Latest activity by jsreynolds1
Still a problem. I'm in SQL2019, full sysadmin rights to server and database. Related to this too I would guess: https://forum.red-gate.com/discussion/91286/prompt-issue-with-updates-on-second-line Attempting to do another set: [image] / comments
Still a problem.I'm in SQL2019, full sysadmin rights to server and database.Related to this too I would guess: https://forum.red-gate.com/discussion/91286/prompt-issue-with-updates-on-second-line ...
Looks like image got bjorked. Here it is [image] / comments
Looks like image got bjorked. Here it is
Hi @cperez I recreated using temp tables so you don't have to have the same data, etc. Same problem exists. When I space away from the dot, I should get a list of columns, but I get almost nothing. Here is the code: SET NOCOUNT ON;
DECLARE @Location VARCHAR(50);
SET @Location = 'Doesntmattter';
DROP TABLE IF EXISTS [#inv];
CREATE TABLE [#inv] ([location] VARCHAR(10), [foo] INT, [bar] INT, [baz] INT);
INSERT INTO [#inv] ([location], [foo], [bar], [baz])
VALUES
('theplace', 1, 2, 3),
('whereever', 1, 4, 5);
DROP TABLE IF EXISTS [#other];
CREATE TABLE [#other] ([location] VARCHAR(10), [foo] INT, [bar] INT, [baz] INT);
INSERT INTO [#other] ([location], [foo], [bar], [baz])
VALUES
('another', 1, 2, 3),
('table', 1, 4, 5);
WITH [specsum] AS
(
SELECT [#other].[location],
SUM([#other].[foo]) AS [foo],
SUM([#other].[bar]) AS [bar],
SUM([#other].[baz]) AS [baz]
FROM [#other]
WHERE CASE
WHEN [#other].[location] = ''
THEN 1
WHEN [#other].[location] = @Location
THEN 1
END = 1
GROUP BY [#other].[location]
)
UPDATE [#inv]
SET [#inv].
FROM [#inv]
INNER JOIN [#other]
ON [#other].[location] = [#inv].[location];
<img src="https://us.v-cdn.net/6029854/uploads/editor/uy/wxwydbyjns67.png" alt="">
/ comments
Hi @cperez I recreated using temp tables so you don't have to have the same data, etc.Same problem exists. When I space away from the dot, I should get a list of columns, but I get almost nothing.H...
Prompt issue with updates on second line
This started happening late last summer and I just haven't been bothered to report it until now.SSMS version 22.30.0SQL Prompt version 10.16.3.14709Basically if I create a temp table and then attem...
@JoshH 10.14.21 was one of the last frequent updates from June 2024 which really worked well, before a series of frequent releases from September on which broke something or another every release. I remember it working back then, probably has been broken like this for me for a couple of months. / comments
@JoshH 10.14.21 was one of the last frequent updates from June 2024 which really worked well, before a series of frequent releases from September on which broke something or another every release. ...
Update statement no auto-complete after first set statement (SQL Prompt 10.16.0.13262)
SQL Prompt 10.16.0.13262, SSMS 20.2.30, Windows 11This has been happening for a while, but got annoying enough today I thought I'd ask.Frequently any column update after the first "Set" column - no...
Issue: SQL Prompt Queries > History > Restore open queries
This has been happening the last couple of hotfix releases, but each time SSMS is closed with open queries, and re-opens, I get copies (sometimes two or three) of each previous tab. So If I closed ...
I've given up; so many issues with the preview releases since after June of this year... this slowness, setting results in an update no longer complete for me, breaking issue with SQL compare, etc. I'm about to just revert to June 14th release when everything 'just worked' and see if I can wait it out. I don't have time to install, uninstall, provide detailed logs, etc. for every little thing that comes along. My bad for trying the preview releases. It was a good run though. / comments
I've given up; so many issues with the preview releases since after June of this year... this slowness, setting results in an update no longer complete for me, breaking issue with SQL compare, etc....
Same, and it was this version, 10.14.23.11448 which started the lagging. It just suddenly feels sluggish. / comments
Same, and it was this version, 10.14.23.11448 which started the lagging. It just suddenly feels sluggish.