Perfroming deletes

  • 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?

  • 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.

  • If that's not a linked server issue, you might indeed be better off posting this here:

    http://www.dbforums.com/f6

    --
    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