.. gibt's da was im SQL..

[malzusrex]

OKay,
habe das jetzt in 2 SQLs gepackt

create view qtemp/x as (
Select RowNumber() over (Partition by feld2 order by kunde, feld2, feld1) as pos, 
kunde, feld1, feld2 from myfile ) 

und dann das Update

Update myfile a 
set Feld3 =
(Select pos from x where a.kunde=x.kunde and a.feld1=x.feld1 and a.feld2=x.feld3) 

Gruß
Ronald

[shapata]

I would like an MD5 value (what it should give ähnlches, also ok) a PF or IFS files generate?
______________
solitaire with buddies

[andreaspr@aon.at]

Hallo,
Das Thema hatten wir sogar vor kurzem:
http://newsolutions.de/forum-systemi...-oder-IFS-File

lg Andreas