How can I declare a variable and use it on the same select for the next column

Copper Contributor

How can I set the same values in column1 and column2. Thanks!

 

DECLARE @Value FLOAT 
SET @Value = 1000.0 + floor(10000 * RAND(convert(varbinary, newid())))
;WITH cte AS
(
  SELECT ROW_NUMBER() OVER (ORDER BY (SELECT 1)) - 1 AS [Incrementor]
  FROM   [master].[sys].[columns] sc1
  CROSS JOIN [master].[sys].[columns] sc2
)
 
SELECT
DATEADD(DAY, cte.[Incrementor], '2020-01-01') Date, 
1000.0 + floor(10000 * RAND(convert(varbinary, newid()))) Column1,
1000.0 + floor(10000 * RAND(convert(varbinary, newid()))) Column2
 
FROM   cte
WHERE  DATEADD(DAY, cte.[Incrementor], '2020-01-01') < GETDATE();
GO

TheYellow_0-1707140401538.png

 

1 Reply