SQL Clone
SQLServerCentral is supported by Redgate
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: 685 | Views in the last 30 days: 1
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


Bones of SQL – Grouping By User-Defined Calendar Periods

Although it is common to group by periods such as Week, Month, or Quarter, sometimes alternative per...