Thanks, Ivan! That did the trick.  I stumbled across that prior to posting but I was reluctant to try because 1.) the name is quite scary and 2.) the article...

Thanks for the feedback.  It's been great help!

Steve - I get what you are saying now.  Here I thought I was doing the analysts a favor by eliminating what seemed to be duplicate data.  I was essentially...

I can't say I've ever had to use them.  However, it seems to do what I need it to upon a quick glance.  I will definitely look into what each...

What are you looking for when you say after I post my actual query?  I'm using the fuzzy lookup transformation within SSIS to do the matching and generate the output...

Thanks, Igor!

I'm running the same exact query and only getting an error message with the linked server so that's why I believe it has something to do with that.

I...

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...