求助 Sql存储过程问题

Create Proc DisTest(

 @Filter varchar (1024), --筛选条件

 @RpFliedName varchar (1024), --重复字段名

 @KeyName varchar (1024), --要删除重复的表的主键名称

 @TableName varchar (1024),	--要删除重复的表的表名称	

 @DelFilter varchar (1024) --删除条件

)

as	

begin

	Declare @userId varchar (1024)

	Declare @MarkId int

	Declare @Pcount int

	exec ('Declare exam_mark_cur cursor for 

		   select  '+@RpFliedName+' from '+@TableName+

		  ' where '+@Filter+' group by '+@RpFliedName+

		  ' having count('+@RpFliedName+')>1'

	) 



	OPEN exam_mark_cur



	FETCH NEXT  from exam_mark_cur INTO @userId



	WHILE @@FETCH_STATUS = 0

	BEGIN

		

		EXEC('Declare current_cur cursor for  

		select '+@KeyName+' from '+@TableName+' where '+@RpFliedName+' =@userId')

		OPEN current_cur

		FETCH NEXT  from current_cur INTO @MarkId

		WHILE  @@FETCH_STATUS = 0		

			BEGIN

				exec('

				select @Pcount=count(*) from '+@TableName+' where '+@RpFliedName+' =@userId')

				IF @Pcount=1

						break				

				exec('delete from '+@TableName+' where '+@KeyName+'=@MarkId	'+@DelFilter)

				FETCH NEXT  from current_cur INTO @MarkId

			END

	CLOSE current_cur

	DEALLOCATE current_cur



	FETCH NEXT  from exam_mark_cur INTO @userId

	END



	CLOSE exam_mark_cur

	DEALLOCATE exam_mark_cur

end