Re: Update table.

From: Kenneth Osenbroch <kenneth.osenbroch_at_canaldigital.com>
Date: 19 Sep 2002 04:40:43 -0700
Message-ID: <9c941a28.0209190340.17832280_at_posting.google.com>


kenneth.osenbroch_at_canaldigital.com (Kenneth Osenbroch) wrote in message news:<9c941a28.0209180407.333dcdf6_at_posting.google.com>...
> Greetings.
>
> Hopefully, some of you can help me with the following scenario:
>
> Table A : Column A | Column B
> . | .
> Value 4 | Value 5
> Value 6 | Value 7
> Value 8 | Value 9
> . | .
>
> I need to uptdate Table A to become:
>
> Table A : Column A | Column B
> . | Value 4
> Value 4 | Value 6
> Value 6 | Value 8
> Value 8 | .
>
> Ergo, I need to take the value from the the first row and update the
> secound row - 1 with it. Any ideas on how to do this?
>
> Thanks,
> Kenneth

Thanks for the reply guys.

I think I need to clarify the mentioned scenario a litle further. The thing is that each record in Column A consists of a character (one single character), and therefor it can't be unique (sorry to have left out this information in my first posting).

So, what I need is to fetch the value from ex. record 3 in row 1 to record 2 in row 2. I think it will be the same scenario as mentioned earlier, bur without the possibility to substract a numeric value.

Is this possible?

Thanks,
Kenneth Received on Thu Sep 19 2002 - 13:40:43 CEST

Original text of this message