Weird Sql Query
DZone's Guide to
Weird Sql Query
by
·
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
Like This Article? Read More From DZone
Topics:
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}