I'm using a linked server.  That appears to be creating the problem.

Thanks for the help, Luis and SQLGuru!  That does exactly what I need it to.  Now I just need to figure out how to get around the error "Msg 125,...

Here are the statements to create the sample data I showed in the screen shot

create table ValueTracking
(
ID int
,[2017_01] int
,[2017_02] int
,[2017_03]...

Everything worked.  I appreciate the help, Sean!

Sean - Thanks for the help!  I'll definitely take your advice.

Hopefully one final quick question...I thought that denying alter on a table would prevent users from performing insert,...

Yeah, I was scared that would be my only/best option.  What about if I deny alter permission to all roles except for the one the users are currently in and...

Fair enough.  Thanks for all of the advice!  I'll hit the books and build from that.

I do have a copy of that but, admittedly, I've only skimmed through picking out key topics and trying to apply them to my own experiences.  I do plan on...

That's definitely something I'm open to the idea of.  Initially I'm looking for some free or very inexpensive resources to get an idea if it's something I can wrap my...

I took care of the duplicates in one table but now I'm having trouble joining tables with a one to many relationship.  I realize this is getting off topic based...

I swear all it takes is to walk away for a minute and things make sense.  It turns out Table1 has some duplicates in it.  Let me clear them out...

I'm bringing this topic back to life because the need for it has come back.  Luckily, this time it is a more scaled back version and I figured out the...

I'll continue to play around with indexing and what not on the joins to see if I can improve that.  For now I've created a physical table using the view...

The base table has ~4 million records.  There are four different lookup tables having record counts of 270, 7000, 24000, and 42000.  The main reason of trying to avoid putting...

Thanks, Brian! That's some really good information and will help me accomplish what I'm trying to do. I'll mess around with it and get back with any questions...