You can do this with a help of
recursive CTE[
^]
;WITH CTE AS(
SELECT @power AS Level5, 1 AS rn
UNION ALL
SELECT Level5 + 10, rn + 1 FROM cte WHERE rn < 100
)
SELECT CTE.Level5, t.name, t.status, t.age FROM
(SELECT name, table2.status, age,
ROW_NUMBER() OVER (ORDER BY table1.id) AS rn
FROM table1 inner join table2 on table2.status = table1.status
WHERE table2.status = 's') AS t
INNER JOIN CTE ON t.rn=cte.rn
SQL Fiddle[
^]