It's difficult to tell if you just want a sum by week (observing the times of the shifts) or if you want the sums by shift.  If the former, the...

Post deleted because the op seemed offended by advice on how to post such problems.,

I agree.  It's been a very long time since I worked with Oracle but semi-colon placement was critical.

Heh, nothing changes.  I find the licks in the article to still be very relevant today and the more than a decade old discussion sound as if it occurred today.

Nothing...

That leads us back to the question I asked that hasn't yet been answered... before the OP makes any "plans", the first thing that should be done is an evaluation...

Also, when you have columns that have the same names except ending with a 1 or a 2, you may also want to look at normalizing the data into...

Hi Jeff

We have to pull in everything from the documents as we don't know what is needed for reporting purposes (orders from the higher-ups).

This is the only document that...

Have you checked seriously to see if you need a table with than many NVARCHAR(MAX) columns?  If so, perhaps you're using the wrong kind of database.  Perhaps a "document" database...

Seeing as his death was in 1791, I certainly hope you didn't...

BWAAAA-HAAAAA-HAAAAAA!!!!  I swear... I didn't do it! 😀

https://getpocket.com/explore/item/the-mysterious-deaths-of-6-historical-figures

Aaaaarrrrrggggghhhhh!!!!!!

Thanks Jeff.

I've just checked and it's been switched off.  This is potentially because we had a bug in our code which meant that the table was being dropped and...

I know a fair number of the heavy hitters that no longer post here. ...

A mix of things. Traffic has declined lately, which is weird.

We depend a log on Google, so we are competing with SO and other places in that sense. Part...

Try moving everything in the WHERE clause to the ON clause.

You're paying a lot of money for AWS RDS.  Unfortunately, it also means that you give up some things because AWS is managing the instance for you.  For example, if...