I figured out how to get it to work myself. Probably not the most elegant, but it might help someone.

DECLARE

@VendorProductINT,

@StartDateDATETIME,

@EndDateDATETIME,

@RoomCountINT

-- We inactivate all current date ranges affected by the impending...

Ok, I've edited the post so it's more readable and understandable. Also, I added the code to build the table being referenced in the query as I brushed up...

I'll study up on how to use inserts and edit the post.

The referenced table is nothing more than a larger table (with a few more columns) of the first grid...

Sorry if this layout is complicated. I'm a little naïve when it comes to posting code into forums.

Let's say I have existing date ranges of:

BlockID ...

Sorry, I wasn't finished and didn't mean to hit post. I'll follow-up with the full question...

Thanks for the great suggestions.

I hate it when I get so wrapped around the axel I overlook some other avenues. I'm already doing some of that when...

Over 50% from my initial attempts! I was pushing about 6 hours and the methods you all proposed and some additional things I had to do given the scope....

Thanks loads guys!!

The whole process still takes about 2 1/2 hours, but it's a whole lot better than before! Most of the time is because of the structure of...

Thanks for the help! This looks promising and I'll play with it some more over the weekend. This has become less of a task and more of a...

Unfortunately no. I was able to get that far, but the issue is how the file is designed. Forgive me if you already have figured out the following.

The...

Awesome! Thank you for your assistance. I'm now able to shred table names out of that mess by modifying it a little so that it looks like:

SELECT T.C.value('@name','VARCHAR(64)')

FROM...