1、账套初始化时,录入往来单位资料后,应收应付的二级科目存在重复的名称。
产品信息:3000XP
版本信息:V8.51
模块名称:初始化
解决方法:
DECLARE @subid varchar(32),
@name varchar(64),
@name_old varchar(64)
DECLARE authors_cursor CURSOR for
select subid,name from subject where name in (
select name from subject group by name having count(*) >2)
order by name /*过滤名称相同的会计科目*/
set @name_old = 1
OPEN authors_cursor
FETCH NEXT FROM authors_cursor into @subid,@name
WHILE @@FETCH_STATUS = 0
BEGIN
if (@name_old = @name)
begin
delete from subject where subid = @subid/*删除不在上述过滤条件的会计科目*/
end
set @name_old = @name
FETCH NEXT FROM authors_cursor into @subid,@name
END
cLOSE authors_cursor
DEALLOCATE authors_cursor |