select  date_add ('20200101',pe.i)   as Day
from posexplode(split(space(datediff('20200401','20200101')),' ')) pe as i,x

select top 100
	SUBSTRING(
    CONVERT(VARCHAR,CAST(
		rand( cast ( newid() as varbinary(16) ) ) * 1000000 + 1 
	AS VARBINARY),2)
	, 4,100)
from  (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10) ) AS MyTable1(a)
cross join (VALUES (1), (2), (3), (4), (5), (6), (7), (8), (9), (10) ) AS MyTable2(a)

select  i,i 
from    (select 1) x lateral view posexplode (split (space (999),' ')) e as i,x