I need to create a string of numbers separated by semicolons that shows how many resources are working on a given week after the start date
- Example:
- I have 3 resources on a project
- Resource 1: 12/31/2012-1/27/2013 (Week 1-4 of our calendar)
- Resource 2: 1/7/2013-1/27/2013 (Week 2-4)
- Resource 3: 1/7/2013-1/27/2013 (Week 2-4)
- tblGRFM.Start will equal 12/31/2012 and tblGRFM.end will equal 1/27/2013
- Cadence should be equal to "1;3;3;3" to indicate that one resource will be working the project the first week, and three resources will be working the project for the next three weeks.
- Any ideas?
I know I'm asking for T-SQL code on an Access forum, but I'm posting this on a few different forums for max exposure.