Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Limuh
Yak Posting Veteran
94 Posts |
 Posted - 2008-02-07 : 04:35:03
|
| I want to compare two tables. if the data is existed to the other table i will insert it to other table if not exist it will load also to diffrent table.Example: if my table was Tbl_StudentID and Tbl_FacultyID i want to insert in tbl_Grade if the data in Tbl_StudentID is exist or present in Tbl_FacultyID . And if the Tbl_StudentId is not exist in Tbl_FacultyID the data will move to Tbl_SupervisorID.Please Help.. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Limuh
Yak Posting Veteran
94 Posts |
Posted - 2008-02-07 : 04:52:34
|
Im using SQL 2000. Thanks is there any ways to solve it? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-07 : 06:09:13
|
| You want this check & insert to happen when you insert on Tbl_Student?If yes, then you can write a trigger for this. |
|
|
|
|
|
|
Getting Value in tables and insert to other tables