merging two tables but only need the matches.

  • Thread starter Thread starter mike11d11
  • Start date Start date
M

mike11d11

I have a dataset with a account table and another table that contains
transactions for accounts in the account table. I create a crystal
report based off an inner join query of the two tables but takes way
too long to generate. I was told if I can get them into one table that
would fix my speed issue. I'm thinking if there is some way to maybe
create a merged table of the two together and only getting data from
both tables where the Account# field matchup? Any help or ideas would
be great!
 
Hello mike11d11,

http://groups.google.com/groups/search?q=dotnet+merge+datatable
m> I have a dataset with a account table and another table that contains
m> transactions for accounts in the account table. I create a crystal
m> report based off an inner join query of the two tables but takes way
m> too long to generate. I was told if I can get them into one table
m> that would fix my speed issue. I'm thinking if there is some way to
m> maybe create a merged table of the two together and only getting data
m> from both tables where the Account# field matchup? Any help or ideas
m> would be great!
m>
---
WBR,
Michael Nemtsev [C# MVP] :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsch
 
Hello mike11d11,

BWT, why not to perform joins on the DB and get the final result?

m> I have a dataset with a account table and another table that contains
m> transactions for accounts in the account table. I create a crystal
m> report based off an inner join query of the two tables but takes way
m> too long to generate. I was told if I can get them into one table
m> that would fix my speed issue. I'm thinking if there is some way to
m> maybe create a merged table of the two together and only getting data
m> from both tables where the Account# field matchup? Any help or ideas
m> would be great!
m>
---
WBR,
Michael Nemtsev [C# MVP] :: blog: http://spaces.live.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche
 
I thought of that, but I have a filtering process that removes accounts
from the table as people work the records. They might start with 5K
account records and then filter it down to 2K records. If I do the
join off the amount of records on the server then my report would
reflect the 5K records and there transactions and not the 2K that I
want to see at that time.
 
Back
Top