CREATE PROCEDURE dbo.UF_Rpt_TryCalculateBalance(
@acct as nvarchar(10)=null
,@unit1 as nvarchar(30)=null
,@unit2 as nvarchar(30)=null
,@unit3 as nvarchar(30)=null
,@unit4 as nvarchar(30)=null
,@su1 as bit=0
,@su2 as bit=0
,@su3 as bit=0
,@su4 as bit=0
,@year as int=null
,@period as int=null
,@unposted as bit=0
,@LocalId as varchar(50)=null
)as
begin
Declare
@sql nvarchar(4000)
,@groupby nvarchar(1000)
,@table nvarchar(2000)
,@addcol nvarchar(200)
set @groupby='acct'
set @addcol=',null as acct_unit1,null as acct_unit2,null as acct_unit3,null as acct_unit4'
if @su1=1
begin
s
[SyteLine]试算平衡表的存储过程修改版
最新推荐文章于 2021-01-19 17:41:33 发布
本文介绍了对SyteLine系统中试算平衡表的存储过程进行的修改和优化,旨在提升财务数据处理的效率和准确性,涉及SQL编程技术。
摘要由CSDN通过智能技术生成