如何在一年中的某一天使用Microsoft SQL中的“一天”并将其“打包”？用于材料要求的制造场景

I have a need to create a gross requirements report that takes how much supply and demand of a item in inventory from a start date onwards and 'buckets' it into different weeks of the year so that material planners know when they will need a item and if they have enough stock in inventory at that time.I have a need to create a gross requirements re