Click here to monitor SSC
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.

http://beyondrelational.com/puzzles/challenges/111/transforming-monthly-resource-efforts-into-weekly-actuals.aspx

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

First Absence of the Week in a Monthly Pay Period

Weekly flag of first Absence for monthly pay period

FORUM

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...

BLOG

July 2013 – Monthly SQL Server Checklist

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

FORUM

Count Months (periods) on program

Need to counts periods and spells on a program

ARTICLE

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...

Tags
 
Contribute