That is fascinating.

Is there also a question?

Hint: read the links How to post forum questions[/url] and Need an answer? No, you need a question.

ps: just to shove you in the right direction: group by week (use the DATEPART function to find the week) and count the orders.