Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
olibara
Yak Posting Veteran
94 Posts |
 Posted - 2014-09-24 : 13:21:05
|
| Hello I have a problem that may sound trivial but it is not at all !I have a table of articles with two dates- CreationDate- ReceptionDateI have to produce a count by week for items to be received ASYear Week Qty2014 1 202014 2 252014 3 182014 5 21etcN.B. : I also have access to a calendar table Thanks for any help |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-09-24 : 17:15:42
|
| How do you define a week - is it Jan 1 to 7, or is it ISO Week, or something else? Does your calendar table have week numbers in it as a column? |
 |
|
|
olibara
Yak Posting Veteran
94 Posts |
Posted - 2014-09-25 : 04:00:13
|
| Hello James,The definition of the week is not realy the issue, and yes I have the week in my calendarMy issue is to count what was not receive for each weeks of the year |
|
|
|
|
|
|
Count NOT received by Week