Joining to empty tablecausing problem

  • Ok, got it working just like we need. Thanks to everyone that helped.

  • Okay, your turn. Would you please explain how you got it working (others may have a similiar problem to yours)? Also, are you still using a cursor?

    😎

  • I just tweaked your last post to work for our data.

    I also wrote triggers for all the tables involved to do the inserts.

    The procedure created from your post is used to convert legacy data.

  • Two questions still. One, were you able to eliminate the cursor. Two, were you able to increase performance of the process?

    😎

  • Yes,using your technique, and Yes, 10-fold!

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply