Hello Everyone,
My Source data is structured as below,
Number (PK) Name State AppointedState Lines
1 Michael CO CO A
1 Michael CO CO H
2 George HI AZ A
2 George HI AZ H
3 Cindy AR AR H
3 Cindy AR CA A
3 Cindy AR CA H
3 Cindy AR IA A
3 Cindy AR IA H
3 Cindy AR ID A
3 Cindy AR KY A
3 Cindy AR OH A
4 Steven AR AZ A
4 Steven AR BA A
Since this is having multiple values of primary key, how should I go about it to do an update else insert strategy.
My Source data is structured as below,
Number (PK) Name State AppointedState Lines
1 Michael CO CO A
1 Michael CO CO H
2 George HI AZ A
2 George HI AZ H
3 Cindy AR AR H
3 Cindy AR CA A
3 Cindy AR CA H
3 Cindy AR IA A
3 Cindy AR IA H
3 Cindy AR ID A
3 Cindy AR KY A
3 Cindy AR OH A
4 Steven AR AZ A
4 Steven AR BA A
Since this is having multiple values of primary key, how should I go about it to do an update else insert strategy.