Posted by: virusno1 January 20, 2011
Login in to Rate this Post:
0 
? 
?
That should be very easy.
Declare @var1 varchar(255)
Declare @var2 varchar(255)
fetch next from cur into @var1
while @@Fetch_status=0
begin
Set @var2=@var1
fetch next from cur into @var1
if (@var1=@var2)
begin
do something
end
end
Declare @var1 varchar(255)
Declare @var2 varchar(255)
fetch next from cur into @var1
while @@Fetch_status=0
begin
Set @var2=@var1
fetch next from cur into @var1
if (@var1=@var2)
begin
do something
end
end