View Single Post
  #10 (permalink)  
Old June 3rd, 2004, 09:11 AM
Hal Levy Hal Levy is offline
Friend of Wrox
Points: 3,489, Level: 24
Points: 3,489, Level: 24 Points: 3,489, Level: 24 Points: 3,489, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Central, NJ, USA.
Posts: 1,102
Thanks: 0
Thanked 2 Times in 2 Posts
Default

There is no reason to get SQL server involved with this proccess at all. Your making this much harder than you need to.

Load two datasets into .NET. Compare the datasets. Update the datasets as required.. write them back to the Sybase databases.

Then, you can update a table in SQL or Sybase with a list of the non-matching records.





Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
Reply With Quote