DELETE CONSECUTIVE DUPLICATES

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 14, 2009 at 10:20 pm

  #1039766

  Started off making this harder than it was. here is the code I came up (also note how I set everything up, as this is how you should post your questions):

  create table dbo.Word (

  WordId int,

  KeyWord varchar(16)

  );

  insert into dbo.Word

  select 1, 'banana' union all

  select 2, 'apple' union all

  select 3, 'cherry' union all

  select 4, 'orange' union all

  select 5, 'orange' union all

  select 6, 'apple' union all

  select 7, 'orange' union all

  select 8, 'melon' union all

  select 9, 'blackberry' union all

  select 10, 'orange' union all

  select 11, 'orange' union all

  select 12, 'orange' union all

  select 13, 'melon' union all

  select 14, 'melon' union all

  select 15, 'melon' union all

  select 16, 'melon';

  select

  w1.*

  from

  dbo.Word w1

  left outer join dbo.Word w2

  on w1.WordId = w2.WordId + 1

  where

  w1.KeyWord coalesce(w2.KeyWord,'');

  drop table dbo.Word;

• monzulu

  Mr or Mrs. 500

  Points: 588

  More actions

  August 17, 2009 at 5:00 am

  #1040091

  thanks very much lynn, i will try that.

  have a nice day.