Try this:
DECLARE @n INT = 2;
;WITH cte AS
(
SELECT TOP(10) Value = ROW_NUMBER()
OVER (ORDER BY[object_id]) FROM SYS.ALL_OBJECTS
)
SELECT Value,
@n AS Multiplier,
Value * @n AS Result
FROM cte;
You should end up with 10 rows that show the value (1-10), the multiplier (in this case, it's 2), and the result of multiplying the value by the multiplier.
If you want more than 10 rows, just change the
TOP(10)
clause to the reflect the desired value.