Is there a reason you are using the group by in this case? Have you attempted to run this on a smaller set of data with and without the...

I am currently working on a business intelligence solution for a variety of systems. The end goal is to have a data warehouse that enables our customers to pull...

Thanks for this script - I had been looking around for something to cover the time of day dimensions - and your script works quickly and thoroughly!