Re: Combining multiple datatables on a unique ID

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: 11Oppidan (11Oppidan_at_community.nospam)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 15:45:27 -0000

I am not sure what you mean by coordinate tables.

I have 100 datatables in a dataset. Each table has been populated by an
individual query. Each datatable contains an event id, value1, value2,
value3 and value4, with about 10k rows. There are a finite number of event
ids app 100k. Each datatable can contain any combination of these events
ids.

I want to create one master table by appending all these different tables
together and then grouping by the Event ID and summing the values. So I
will have a final table containing the eventid once and the sum of the
values from all the different tables I have combined.

Hope that makes sense! As William said this is perhaps something that
should be done server side. I am just keen to establish how to query across
datatables!

Thanks for your help.

"Kevin Yu [MSFT]" <v-kevy@online.microsoft.com> wrote in message
news:cPBuKdQKFHA.1140@TK2MSFTNGXA02.phx.gbl...
> Hi 11Oppidan,
>
> DataRelation objects create relationship between master and detail tables.
> However, based on my understanding of this issue, you have coordinate
> tables to do this summary. So I don't think DataRelation is suitable here.
> Please feel free to point me out if my understanding is incorrect. Thank
> you.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>