Thank this author by sharing:
By Jacob Sebastian, 2012/03/05
In a large project management application, there is a category of resources which are managed in a special way. During the planning phase you have an activity with a planned start date and a planned finish date and a monthly sequence of estimated effort values for one or more resources. A period always refers to a real calendar month with period 1 being the month of the planned start date. But the first period and last period may not use up a full month.
http://beyondrelational.com/puzzles/challenges/111/transforming-monthly-resource-efforts-into-weekly-actuals.aspx
Weekly flag of first Absence for monthly pay period
Comments posted to this topic are about the item [B]TSQL Challenge 77-Transform monthly resource ef...
Need to counts periods and spells on a program
one period can not overlap multiple months
How to Calculate Total Monthly time worked
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
