split id s compare two columns values

Thulasiram pakala

table1

id

Tabel 2 id row1 store 1,2

           row2store 3,4

now i need to comparethis table 1 and table 2 values nedd to display 5,6,7,8 values only

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
In case you wish to avoid cursor another solution exists with the use of CROSS APPLY.
Nitin Sontakke9y ago
Complicated. These are the typical hazards of not holding the data in a normalized form.

Solution:

Preferably in a stored procedure, create a table variable with one id column.

You will need to loop through all the rows in a cursor from table 2 and then split the values in the column and insert those values in the table variable declared above.

After above is over then write a following query:

select *
from table1 t1
left outer join @table_variable tv on t1.id = tv.id
where tv.id is null