Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

TSQL Challenge 77-Transform monthly resource efforts to weekly actuals

By Jacob Sebastian,

TSQL Challenge 77 - Transforming monthly resource efforts into weekly actuals

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.

Total article views: 677 | Views in the last 30 days: 2
Related Articles

First Absence of the Week in a Monthly Pay Period

Weekly flag of first Absence for monthly pay period


TSQL Challenge 77-Transform monthly resource efforts to weekly actuals

Comments posted to this topic are about the item [B]TSQL Challenge 77-Transform monthly resource eff...


July 2013 – Monthly SQL Server Checklist

First Monday of the month and time to update the monthly SQL Server checklist.  Monthly SQL Server...


Count Months (periods) on program

Need to counts periods and spells on a program


July 2014 – SQL Server Monthly Maintenance Checklist

image source It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist....


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

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

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones