0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professors, theologians, and those interested in exegetical analysis of biblical texts

select wk, round(count(*),0) qpd
from( select concat(datepart(year,creationdate)
                   ,'W'
                   ,format(datepart(week,creationdate),'00')) wk
      from posts
      where posttypeid=1 
            and creationdate< dateadd(day, 1-datepart(weekday, getdate()), getdate()) ) z
group by wk
order by wk desc;

view current version

edited jan 17 19

created jan 17 19 Jack.Douglas