[SyteLine]试算平衡表的存储过程修改版

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
    set @groupby=@groupby + ',acct_unit1'
    set @addcol=replace(@addcol,',null as acct_unit1','')
  end
  if @su2=1
  begin
    set @groupb