November 30, 2004 at 7:14 am
I am having an issue deleting duplicate rows in Sybase. I have a query
(DELETE x
FROM test x
WHERE (select count(*)
FROM test t
WHERE t.test1 = x.test1 AND
t.test2 = x.test2 AND
t.test_id <= x.test_id ) > 1)
that works correctly in SQL 7.0, but does not work in Sybase. Does anyone have a workaround as a delete query to do this for Sybase, without using a cursor?
November 30, 2004 at 7:17 am
Sorry matey,
This is a Sequel Server forum - if it works in Sequel 7 - its good enough for me........
Have fun
Steve
We need men who can dream of things that never were.
November 30, 2004 at 7:25 am
If that's not a linked server issue, you might indeed be better off posting this here:
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply