Dataset Multi-Table Row changes

Hi All,

After quite a bit of searching through the newsgroups I have been able
to fill a dataset with two tables using two separate datadapters.

What I need to do now is to update the records in table1 based on the
records in table2.

A simplifed example

Table1 ' When loaded Level is Hi All,

After quite a bit of searching through the newsgroups I have been able
to fill a dataset with two tables using two seperate datadapters.

What I need to do now is to update the records in table1 based on the
records in table2.

A simplifed example

Table1 ' When loaded Level is NULL
GUID|LastName|Score|TestDate |Level
0000|TEST1 | 7 | 5/6/05 | Hi All,

After quite a bit of searching through the newsgroups I have been able
to fill a dataset with two tables using two seperate datadapters.

What I need to do now is to update the records in table1 based on the
records in table2.

A simplifed example

Table1
GUID|LastName|Score|TestDate | Level |
0000|TEST1 | 7 | 5/6/05 | NULL |
0001|TEST2 | 21 | 5/6/05 | NULL |
0002|TEST3 | 15 | 5/6/05 | NULL |
etc.

Table 2
GUID|StartDate|EndDate|MinScore|MaxScore|Level |
A000|1/1/00 | NULL | 0 | 10 | Level 1 |
A001|1/1/00 | NULL | 11 | 23 | Level 2 |
A002|1/1/00 | NULL | 24 | 39 | Level 3 |
etc.
NOTE: Enddate can be NULL all other are NOT NULL
A NULL enddate means to use today as the enddate

The results I need to acheive would be:

So Table 1 would look like
GUID|LastName|Score|TestDate | Level |
0000|TEST1 | 7 | 5/6/05 | Level 1 |
0001|TEST2 | 21 | 5/6/05 | Level 2 |
0002|TEST3 | 15 | 5/6/05 | Level 2 |
etc.

My questions:
1) Is this possible through teh dataset by an SQL query?
(If I need to loop record at a time, this would take an extremely long
time as there are 8 different score to look up per record.)


2) Would I be better creating a stored procedure on the SQL server to
acomplish this.
(The goal was to offload to the client as much as processing as
possible)


Thanks in Advance,

Mike
.

Relevant Pages

  • Re: Search function in this discussion group
    ... I can see at least 3 posts with "password" in their title. ... What is the secret to searching on Microsoft.com ... set up a newsreader instead (very easy to ... information about newsgroups: ...
    (microsoft.public.windowsxp.general)
  • Re: Question about offering solutions here (head up, MVPs!)
    ... It always amazes me that people can find newsgroups but not find Help. ... I think that people think of searching Help as searching through an ... Windows there is a lot of computer terminology that people are just plain ...
    (microsoft.public.windowsxp.general)
  • Re: help understanding authentication on workgroups
    ... In all my searching I didn't end up seeing the links you provided. ... I just wanted you to know that this isn't a "forum" and there ... some links to information about newsgroups: ... Using Outlook Express as Newsreader: ...
    (microsoft.public.windowsxp.network_web)
  • Re: Usenet Servers And Groups
    ... newsgroups is to go to Google, but instead of searching the internet ... Google will display the posted messages along with the name of the ... can anyone recommend another good Usenet server ...
    (microsoft.public.macintosh.general)
Loading