I would think another big factor holding some back could be licensing.  Not everyone pays for Software Assurance.

Well, you are definitely not crazy.

EDIT: I also have Redgate's SQL Prompt installed so I thought it might be a custom shortcut as Luis suggested but I couldn't...

Lol, fair enough...maybe not the first thing. But since I just started a few months ago at my new employer I don’t have much vacation time. So sadly, it won’t...

It's about time!  I got an early Christmas present today when I received my Redgate activation keys.  😀

Had the tools approved at previous employer but at the last...

Ok, I didn’t see it before but that’s an interesting take. I’ll give it a try when I get into the office on Monday. Surprisingly, my code ran pretty fast...

If you looked at my sample data you’d see I don’t have a start and end time for event. It’s assumed the end time is the start time of the...

I did end up with a working solution but I should probably elaborate since I seem to have missed the mark explaining my problem.  I have a very busy event...

Thanks for the input Jonathan.  Although it does look like you are working with my original idea since you are using act_time.  Though time is seperate from date in my...

Just seeing this post pop up again reminded me I needed to thank you Jeff (again) for this.  I've used this several times now at 3 different employers.  Made me...

Ok, so I came up with a different method that only expands out the data set rather than create a timeslot for every second.  I think it's much cleaner and...