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 |
|
ag_ss
Starting Member
48 Posts |
 Posted - 2006-04-04 : 02:39:05
|
| if exists (select 'x' from obj where new_obj.key1 = obj.key1 and new_obj.class = obj.class) BEGIN set @temp_old_ref = (select obj.rowid from obj where new_obj.key1 = obj.key1 and new_obj.class = obj.class) SET IDENTITY_INSERT new_obj ON insert into new_obj(rid, key1, class, is_searchable, is_deleted, is_loaded, old_rid, old_ref) select rid, key1, class, is_searchable, is_deleted, is_loaded, old_rid, @temp_old_ref from new_obj delete from new_obj where old_ref != @temp_old_ref ENDwhile running it i m getting this errorMsg 4104, Level 16, State 1, Procedure mergeChanges, Line 35The multi-part identifier "new_obj.key1" could not be bound.Msg 4104, Level 16, State 1, Procedure mergeChanges, Line 35The multi-part identifier "new_obj.class" could not be bound.Msg 4104, Level 16, State 1, Procedure mergeChanges, Line 37The multi-part identifier "new_obj.key1" could not be bound.Msg 4104, Level 16, State 1, Procedure mergeChanges, Line 37The multi-part identifier "new_obj.class" could not be bound.any thoughts |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-04 : 02:52:09
|
| if exists(select 'x' from obj, New_Obj where new_obj.key1 = obj.key1 and new_obj.class = obj.class) set @temp_old_ref = (select obj.rowid from obj,new_obj where new_obj.key1 = obj.key1 and new_obj.class = obj.class)you missed out new_obj in the from clause.. If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
ag_ss
Starting Member
48 Posts |
Posted - 2006-04-04 : 03:06:28
|
| thanx it worked |
|
|
|
|
|
|
|
|
The multi-part identifier