Thank this author by sharing:
By Jacob Sebastian,
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.
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.