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
Database
sql
Opinions expressed by DZone contributors are their own.
Comments