Problem mit LöschAbfrage.. ältesten Datensatz beibehalten alle anderen löschen

moin KarlChristian
so wäre es eleganter gewesen

USE deine_tabelle
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
DECLARE @del1 int, @del2 int, @datum date

DECLARE cursor_del1 CURSOR scroll for
select distinct(ref), abfragedatum
from deine_tabelle
order by ref, abfragedatum

OPEN cursor_del1
FETCH NEXT FROM cursor_del1 INTO @del1, @datum
WHILE @@FETCH_STATUS = 0
BEGIN
DECLARE cursor_del2 CURSOR scroll for
select ref
from deine_tabelle
where ref=@del1
order by abfragedatum
OPEN cursor_del2
FETCH FIRST FROM cursor_del2 into @del2
FETCH NEXT FROM cursor_del2 into @del2
WHILE @@FETCH_STATUS = 0
BEGIN
delete from deine_tabelle
where current of cursor_del2
FETCH NEXT FROM cursor_del2 INTO @del2
END
CLOSE cursor_del2
DEALLOCATE cursor_del2

FETCH NEXT FROM cursor_del1 INTO @del1, @datum

END

CLOSE cursor_del1
DEALLOCATE cursor_del1

cu Rainer