From: Beermann, Albert (A.Beermannpiepenbrock.de)
Date: Fri May 11 2007 - 02:51:20 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello Everybody

I use Maxdb 7.6

I need an idea for the following problem

Table xyz

id = unique key

pnr

auftrag

jahr

monat

vorgabe1

vorgabe2

vorgabe3

vorgabe4

I have one record for

pnr(111),auftrag(xxx),jahr(2007),monat(5)

I have 6 future records for the same pnr,auftrag combination !!

pnr(111),auftrag(xxx),jahr(2007),monat(6)

pnr(111),auftrag(xxx),jahr(2007),monat(7)

...

pnr(111),auftrag(xxx),jahr(2007),monat(11)

Only the actual record(2007,5) has correct vorgabe1 to vorgabe4 values

Now i have to push vorgabe1 to vorgabe4 from the actual record into the
6 future records!?

Can this be done with an sql command ???

Any help welcomed

Best regards

Albert

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]