I wound up in a highly similar position implementing 'immediate fixes' and never able to get to long-term solutions to stop all the 'immediate fixes.'  It forced me into...

IMHO, "Most Reads" doesn't tell you anything other than a title possibly having a great amount of SEO.  People could be opening an article and getting one sentence in and...

So...

This is so wrong.  Your company is trying to have you fix the wrong problem.  The real problem is the source of the data...

This is so wrong.  Your company is trying to have you fix the wrong problem.  The real problem is the source of the data and THAT's...

Using the test data provided by the OP...

   WITH cteWeekAgg AS
(
 SELECT  StaffID
        ,WeekStart  = DATEADD(dd,DATEDIFF(dd,0,StartDatePeriod)/7*7,0)...

The first to the check for is <insert drum roll here> are you using any monitoring software?

Yes......

Hi ,I would like to split a given number into 3 numbers based on a percentage(98.6% , 1.2%  and 0.2%) and round it to an integer value and the...

How many von/bis dates are you feeding this thing from the zugriff.dim_spell table?  And how much (or little) memory do you have available on the SQL Server?

Also, I wish I...

My apologies.  I was on vacation last week (but got emergency calls for 17.5 hours of work) and have been slammed for the day.  I've got commitments from now until...

Hi Jeff,

the translation worked :-). I will test it on the large data set right away. The date format is just Excel being Excel where I prepared the demo....

This is so wrong.  Your company is trying to have you fix the wrong problem.  The real problem is the source of the data and THAT's what actually...

I hope the translator is working correctly but, to answer the question above, "Ja. Und es'ist blitzschnell! "

First, I have...

Instead of going through it all yet again, I'll summarize just by saying that's total rubbish.