Sample interest weighting procedure

Hi Gawain. Thank you for the input.  Unfortunately, I am not very familiar with formatting code on my own.  Would you be able/willing to lend a hand with updating that statement to update using the Merge statement like you mentioned? It would be greatly appreciated!

Haha!  I was hoping you wouldn't ask that.  I'm just starting to figure out MERGE myself (and very stupidly annihilated almost all of our Interests a few months ago because I included a DELETE clause without thinking it through -- we were able to recover them from a backup, thanks Support!)

Is it embarrassing to admit that I just never liked dealing with MERGE, so I just always UPDATE existing, DELETE those from my temp table and then INSERT the new ones?

I'm warming to it, but it is a sharp tool.

Also, is it one of the ones that bedevils intellisense?  Can't remember.

I cannot recall either.  I guess a part of me just always feels a little safer separating out the actions on their own.  And nothing I am doing with that is ever so database intensive (and usually is done at 3:00 AM) that it makes even the slightest difference in terms of operational capacity.

I do feel like once I become comfortable with it, it will also make what I'm doing easier for me to read in the future by pulling all the logic into one place.

And becoming more comfortable with and expanding your knowledge on a standard SQL process is rarely ever a bad thing.

Unless other people find out your skills and line up in front of your desk to do all their jobs.  That's why it's better to be SQL Batman and solve database crimes out from the shadows.

Unless other people find out your skills and line up in front of your desk to do all their jobs.  That's why it's better to be SQL Batman and solve database crimes out from the shadows.