Platinum Partner

Weird Sql Query

// 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
{{ tag }}, {{tag}},

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}
{{ parent.authors[0].realName || parent.author}}

{{ parent.authors[0].tagline || parent.tagline }}

{{ parent.views }} ViewsClicks
Tweet

{{parent.nComments}}