Weird Sql Query
Join the DZone community and get the full member experience.Join For Free
// description of your code here
select convert(varchar(8),dateadd(dd , i.i * -1, dte.d ),112) from (select 0 AS I union all select 1 union select 2 union select 3 union select 4 union select 5 union select 6 ) i CROSS join (select dateadd(dd,0,getdate()) AS D) dte order by dte.d desc
Opinions expressed by DZone contributors are their own.