Prompt issue with updates on second line

• 
  Hi @jsreynolds1,
  
  Thanks for reporting this issue to Redgate Support, I have tested this some and I think I may have this issue replicated, however, could I kindly ask that you provide the above query not as a screenshot but as actual text, I would like to test on your specific query and ensure the behavior is the same.
  
  Cheers,
  
  Product Support
  
  

  cperez January 30, 2025 16:05

  - 0 +
• 
  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="">
  

  jsreynolds1 January 30, 2025 16:48

  - 0 +
• 
  Looks like image got bjorked. Here it is
  
  
  

  jsreynolds1 January 30, 2025 16:49

  - 0 +

Add comment

Please sign in to leave a comment.