I would like to run an insert to a table to insert a new row for each distinct id within the table.
the current data may look like this
I would like the insert to see id's 100 and 200 and insert a row for each if the data column content does not exist.
for example the insert would not add a 200|test2 but would add a 200|hellothisisatest
Thanks in advance.