WOW!

Ok so a little more background, the DDL was just a made up example that I thought if cracked would provide the solution to my real dataset.

Thought being the definative word.

The solution above does indeed work for multiple employees but only on a single date.

I began a backdate on Friday and when I looked at the results it all went Pete Tong.

So i've read over your explanation a good 5-6 times and still cant get my head round it (tbh I fell at the first hurdle when you mentioned HULU (wtf is hulu lol) - then I realised as I'm british it's acceptable to not know what hulu is 😉

Anyway to the point, I've implemented your solution this morning and... Bang, the dirt is gone 🙂

Worked a treat.

I had to strip out the media type as I can report on them seperately, my solution was just to get the logged hours for the agent for the day.

Thanks Celko 🙂