clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601556 fiddles created (47965 in the last week).

with cte as ( select 1 as col1, getdate() as col2 union all select col1 + 1, col2 from cte where col1 < 4 ) select * from cte
col1 col2
1 20/12/2019 17:28:37
2 20/12/2019 17:28:37
3 20/12/2019 17:28:37
4 20/12/2019 17:28:37
 hidden batch(es)