Perfroming deletes

• brownguyr

  SSC Enthusiast

  Points: 107

  More actions

  November 30, 2004 at 7:14 am

  #65404

  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?

• Ste_P

  SSCarpal Tunnel

  Points: 4430

  More actions

  November 30, 2004 at 7:17 am

  #531854

  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.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 30, 2004 at 7:25 am

  #531855

  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]