I am trying to read in text data from a field in one table and then append it to data in a second table, but only if its unique. Any thoughts on how best to do that?
Ex Table A has:
bug #12345
bug #67890
And Table B has:
The following bugs are
bug #12345
Now I want to select the data from A and add the unique information (bug #67890) to B.
Thanks.
bill robson
Last Activity: Jul 5 '06, 08:58 PM
Joined: Jun 15 '06
Location:
-
Update unique records only help
-
Copying non duplicated data
Hi. I am stuck and was hoping for some help. I am using MSSQL and I need to extract data from one field (A) and append it to a second field (B) but only if the data in (A) does not allready exists in (B). The querry is run many times so the (B) field should only grow when something new is added to (A).
EX.
Field (A) = 123
Field (B) = ""
After first sql command
Field (A) = 123
Field (B) = 123...
No activity results to display