update duplicate row with sequence number

• Question

• 

  

  0

  Sign in to vote

  Hi Iam using sql 2000. I need a query to update the duplicate rows in table
  with sequence number and leave the unique rows
  for eg,
  
      tbl_register (existing)                 
  regno         rowid
     1             null
     1             null
     2             null
     3             null
     4             null
     4             null
  expected result
  
      tbl_register
  regno         rowid
  
     1             1
     1             2
     2             null
     3             null
     4             3
     4             4
   Please help me to sort out thhis issue
  
  with thanks and regards
  Sathia
  
  

  Thursday, November 26, 2009 11:32 AM