Hi All, I am trying to come up with a query which returns a given number of rows without having a real table on Storage.
I am hoping to achieve something like this: http://stackoverflow.com/questions/6533524/sql-select-n-records-without-a-table DECLARE @start INT = 1;DECLARE @end INT = 1000000; WITH numbers AS ( SELECT @start AS number UNION ALL SELECT number + 1 FROM numbers WHERE number < @end)SELECT *FROM numbersOPTION (MAXRECURSION 0); I do not actually need to create different values and returning identical rows would work too.I just need to bypass the "from clause" in the query. Thanks, Alex