I want To get value of column when it exist in content value of column by sql server 2016
For Example:
Table1:
Title1
----
Jack
Benz
Volvoo
Table2:
Description Names
---- ---------
The Jack isnt A122 NULL
Some B1234 Benz NULL
This Volvoo Are C NULL
This Maria Are D NULL
Michael Jackson NULL
example:
Search Row By Row From table 1
in the row by row column Description
in Table 2
and get value and insert to cloumn Names
IF Jack
or Benz
Or Volvoo
exist in The Jack isnt A122
get Jack
and Update column Names
in Table 2
Description Names
---- ---------
The Jack isnt A122 Jack
For 'Jack owns a Benz'
that matches 2 titles (Jack and Benz), update with either one of them.
For Other Rows in Table 2 same:
Description Names
---- ---------
The Jack isnt A122 Jack
Some B1234 Benz Benz
This Volvoo Are C Volvoo
This Maria Are D Others
Michael Jackson Others
- The tables do not have primary keys.
Table1 (Title1)
isUNIQUE
.