If the file named file_data_181203.txt.zip contains the file named file181203.txt, then it's pound foolish to copy the txt file along with the zip file.  Gross duplication of data.  Just drop...

Now that there are multiple solutions for this problem, I have to ask, if the "current" start date will be replaced with the previous end date, why is there any...

By the same token, a lot of people think that "set-based" means "all in one query".  While set-based code frequently does result in a single query, it's not always the...

You seem to be missing some Primary Keys from some of the tables.  While an actual primary key isn't always uber important, clustered indexes usually are.  Also, MS like for...

Ok... here's what I've found out about the XML index that Magoo suggested.  Regardless of the outcome, his suggestion was a great idea that needed to be tested.  Thanks again,...

Thanks for the feedback! 😉

I haven't.  I'll give that a try.  Thank you