Comments
Sort by recent activity
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...
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 ...
@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. ...
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.
Arrg. This is not good. I use SQL Prompt, SQL Compare and other stuff multiple times a day. I guess I'm going to have to give it a go. / comments
Arrg. This is not good. I use SQL Prompt, SQL Compare and other stuff multiple times a day. I guess I'm going to have to give it a go.
I have a support ticket open on this. So far I was asked to uninstall all products, reboot, download the latest Toolbelt installer, install, and try again. I did so, no joy. I then took steps to locate all possible registry entries, data in AppData, Documents, etc. and delete so it could start as “fresh” as possible. I then uninstalled and re-installed - same issue. I then uninstalled and installed an older version from June 2024 - same issue. I've submitted many internal bug reports through the pop-up before it crashes. Hopefully this may help. I'll keep you updated as things progress or if I figure out something. / comments
I have a support ticket open on this. So far I was asked to uninstall all products, reboot, download the latest Toolbelt installer, install, and try again. I did so, no joy.I then took steps to loc...
The cadence of releases as of late seem a bit slower than before. SQL prompt early releases (and other SQL Server Red-Gate products) were coming at quite a clip (one or two a month), and suddenly have dried up since mid-late July. Not sure if it's just vacation/summer time for them. :-) / comments
The cadence of releases as of late seem a bit slower than before. SQL prompt early releases (and other SQL Server Red-Gate products) were coming at quite a clip (one or two a month), and suddenly h...