Hi Alan,

Thank you for the update and help !!

So I ran the update script for the period of 05/01/2016 to 05/31/2016 and I'm not sure why I'm getting two Week...

Hi Alan Burstein,

I ended up using your solution so thank you VERY MUCH 🙂

I just have two questions for you, first, how can I change the start date to start...

Hi Sergiy,

I really appreciate all of the help from you and the rest of the awesome group !!

I have three solutions now and I just have to pick the one...

Hi Alan.B,

This is great and works really well 🙂

Thank you for this solution !!

Hi Lynn Pettis,

This is going to take some time to digest as there is a lot to learn from these articles.

I thank you for directing me to these reads and...

Hi Lynn Pettis,

Got it :w00t:

This is it then, these are the results I was after so thank you once again !!

Have a blessed day 🙂

Hi Sergiy,

I'm sorry I'm lost 😉

Can you kindly add the initial piece (where we create the Calendar table) into your query?

Sorry and thanks again for your help.

Hi Lynn Pettis,

That's exactly the results I need so THANK YOU very much !!

But... I don't know two things, so if you could please help me 🙂

1. How do I...

Hi Sergiy,

Do I need to create the BusinessCalendar table first?

I'm getting an unknown invalid object name error.

Thank you.

Hi Sergiy,

In this case, it would be like the following:

STARTDATE ENDDATE ...

Thanks to both twin.devil and Lowell for the quick solution, that's exactly the output I was looking for and presented to the client however ..

The client now added a twist...

Hi There,

That's exactly what I ended up doing and now I'm getting the accurate results 🙂

THANK YOU ALL for ALL your help !!

Okay, so I was able to resolve this issue by changing the formatting to getting the hours from the minutes column by using the following:

CONVERT(varchar, DATEADD(ms, TIMEINSECONDS * 1000, 0),...

Hi There,

My mistake, I just went back and checked, the hours are like '3.5' and '4' instead of 03:30 and 04:00 as initially stated.

So when I ran the

convert(datetime,STARTDATETIME) +...