Combining results from three sources

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello All,
I have to combine search results from three different data sources, two
are separate databases in an SQL server one is a mySQL server database. I
get the search results from each of them in my separate classes. Now I need
to combine them and remove duplicates how do I work with that ?

say
DataSet ds1 has now got three tables source1, source2 and source3 how do I
perform an in-memory query on the dataset tables to get a view that removes
duplicates ?

Imran.


.

Relevant Pages

  • Applications sharing a common table
    ... There are two applications using SQL Server. ... An idea might be to have two separate databases for the applications as well ... as one database for the common tables. ...
    (microsoft.public.sqlserver.programming)
  • SQL Server times out :( - URGENT
    ... separate databases and some "user defined functions" ... are used to perform some calculation before the data is handed over to ASP ... Microsoft OLE DB Provider for SQL Server error '80040e31' ...
    (microsoft.public.sqlserver.server)
  • SQL Server Timing out :( - urgent
    ... separate databases and some "user defined functions" ... are used to perform some calculation before the data is handed over to ASP ... Microsoft OLE DB Provider for SQL Server error '80040e31' ...
    (microsoft.public.sqlserver.server)