Paul Beetge (3/2/2010)

---

Hey Guys,

That's all good and well, but what about actually automating this in a job using a script ? Can anybody help me with a scrip that...

The problem was solved by declaring few variables and using select into statement. Thanks for help...

Thanks Toby for your reply but still there's no luck. The folowing statement has been ignored:

Set t1.parentrefrecid=t2.recid

And on join i got error as well --> sql command not properly...