Just noticed the reply on doing it dynamically. With my limited knowledge that actually does look like a much cleaner way to do it. Gonna toy around with it to...

Thanks Sean, truly appreciated and indeed you had it all right 🙂

I did run into two minor issues, posting them back so this post might prove useful to anybody wanting...

Hmm, getting the LEFT value returned for 20 chars made sense and gave the right result. I'm now trying to implement it within the loop i made but it seems...

Thanks for the reply, i actually did stumble into it but figured it was something for later as i needed a quicker solution (tho i agree with you ssis seems...

Didnt even think of that, managed to get it working along the way like this (query at bottom). I read up on the cursor options and found out that while...

Dear Mister Lowell,

(9465 row(s) affected)

Not only does it work but i actually understand why to go this way. I'm on a SQL course and trying to pick up as much...

I guess i'm partly approaching this wrongly figuring i am still inserting into a field, it makes sense if you narrow it down that it actually inserts as new

First of all, thanks for the reply.

Without the DISTINCT it indeed returns the correct amount of records