Also, ensdure that you shrink the files to the same size. If you have them at different sizes, SQL Server won't make proper use out of them. In your above...

Without knowing the value of @[$Package::FilePath] all we can do is guess.

You've provided DDL, which is a good start, but you still need to supply that sample data in a consumable format.

What do you mean by you need to "insert the 11 based upon the month retrieved from the GETDATE()"? Could you try and explain further? You might need to supply...

Indeed, you would be much better off using parametrised SQL, or (even better) a Stored procedure to do the work here.

Considering that (it looks like) that code would...

Do you actually have a domain at home, or are you using workgroups?

Based the guess that the JOIN is based on ASCENDING order on both sides on the coin, this'll be enough to get your way:

What defines which row belongs to which? For example, why not:
12 67 605059 1001083
Is it ascending order for both sides?

Just gave your script a testand apart from having to amend the date format this ran fine, and even returned the correct value (without changing the nvarchar). That was, however,...

I've not looked too far, but one thing I notice is that your original column is an nvarchar, and you're converting it back to a varchar. You should be converting...

If Lynn's query is returning no results, then there are no triggers with the word "FACTS" in their name in that database.