SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE sp_exec_35to41
@database varchar(60),@bz varchar(5)
AS
begin
declare
@sqlstring varchar(2000)
alter table Acct_t_AcctItem disable trigger all
delete from Acct_t_AcctItem
set @sqlstring = 'insert into Acct_t_AcctItem SELECT AcctCode,AcctName,BalanceDir, Memoric,AuxDept,AuxEnterprise,AuxPerson,
AuxProject,EndFlag,AcctTypeID,Status,Breviary,TaxTypeID,AcctLvlID,SuperID,null,EndFlag,EndFlag,EndFlag,EndFlag
from ' + @database + '.dbo.Acct_t_AcctItem '
exec(@sqlstring)
alter table Acct_t_AcctItem enable trigger all
return
end
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO