Hi ,
I am having two table in sql server server . I want to compare two tables each row data. For ex
having table1 and table2 both table sahing same column. Two user is working on same file and entring the data in database (like Both table are same Empid,EmpName,Add etc.) In My application there are two user first user filling the data in table1 and second user is filling data in table2 on same file . I have one more table which is known as MasterEmpTable in that i want to fill the data which are same in both table. If both table having same data (row value) then it will be goes data in MasterEmpTable other wise if any different value then its its show that row having different value.Can you plz write the stored procuder for that or give some idea how can i solve this issue.