set @Condition = @Condition + ‘ and A.TargetPeriod >=”’ + @TargetPeriodBegin + ””
if (len(@TargetPeriodEnd)>0)
set @Condition = @Condition + ‘ and A.TargetPeriod <=”’ + @TargetPeriodEnd + ””
if (len(@BranchOrgCode)>0)
set @Condition = @Condition + ‘ and F.OrgCode like ”%’ + @BranchOrgCode + ‘%”’
if (len(@BranchOrgName)>0)
set @Condition = @Condition + ‘ and F.OrgName like ”%’ + @BranchOrgName + ‘%”’
if (len(@OrgCode)>0)
set @Condition = @Condition + ‘ and E.OrgCode like ”%’ + @OrgCode + ‘%”’
if (len(@OrgName)>0)
set @Condition = @Condition + ‘ and E.OrgName like ”%’ + @OrgName + ‘%”’
if (len(@SalesCode)>0)
set @Condition = @Condition + ‘ and C.SalesCode like ”%’ + @SalesCode + ‘%”’
if (len(@SalesName)>0)
set @Condition = @Condition + ‘ and C.SalesName like ”%’ + @SalesName + ‘%”’
if (len(@CatalogCode)>0)
set @Condition = @Condition + ‘ and D.CatalogCode like ”%’ + @CatalogCode + ‘%”’
if (len(@CatalogName)>0)
set @Condition = @Condition + ‘ and D.CatalogName like ”%’ + @CatalogName + ‘%”’
if (len(@Condition)>0)
set @Condition = substring(@Condition,5,len(@Condition))
–print @Condition
exec sp_Paging
N”,N”’ as CheckBox, A.TargetID, A.TargetPeriod, Convert(varchar(10), B.BeginDate, 120) as BeginDate, Convert(varchar(10), B.EndDate, 120) as EndDate,
C.SalesCode, C.SalesName, D.CatalogCode, D.CatalogName, E.OrgID, E.OrgName, F.OrgID as BranchOrgID, F.OrgCode as BranchOrgCode, F.OrgName as BranchOrgName, A.Amount, ” as DetailButton’,
