side note, now I need to go update my holiday table and rerun my business day calculation....

If you really want "previous business day" so that running it on Monday gives you Friday data, build a date table. Assign a "businessDay" column and populate another table with...

Well, how do you identify "travel unproductively"? Score each driver/route based on what is there currently, see who your underperformers are, search for common traits or something.

That sounds dangerous, simply because reduced availability will likely drive customers away, so the efficiencies that are assumed to be gained are really lost completely. Customers pay for their own...

If you get bored with "just" answering questions on the forums (hard to imagine, but let's assume that happens) then check out the "articles requested" forum for things Steve is...

Also, you don't have to have a LEFT JOIN just to make a CASE statement work. The JOIN operation is about matching, your CASE statement is simply saying when to...

I stand to be corrected here, but NOLOCK on a #temptable has no effect.  The #temptable is local to your SPID, so there is nobody else reading or writing...

There used to be a specific connection to SharePoint fo rSSIS, been a while since I tried to do that. Are you tryin gto create a list item for every...

I'll be honest, I haven't tried this, but I figured it might be possible. Looks like this might be what you need to start with browsing the multiple files using...

You shouldn't have to redo the shared datasource though, that should still work. I'm wondering if there's a way to do this in the rdl by editing the text, and...

https://royalsocietypublishing.org/doi/pdf/10.1098/rstb.2017.0239 - Open offices actually make people chat and email more. counter-productive.

Also Jeff, youtube has some great "slow tv" videos of train rides through Europe, India, Australia, etc. I...

SQL Compare works well https://www.red-gate.com/products/sql-development/sql-compare/

From the data, it looks like nothing was suspended, so it had no data to display? You're saying when you change the time you have the same issue. Is it...

It's only been four days, never can tell with bees. Congratulations in any case Luis,  wishing you all the best!

HAHAHAHA!!!!   https://arstechnica.com/cars/2019/08/wiseguy-changes-license-plate-to-null-gets-12k-in-parking-tickets/