完成执行语句前已用完最大递归 100。

打开产品成本还原对比分析表，无论哪个用户，过滤出这个物料报错，过滤其他物料正常；
查询出现异常。语句被终止。完成执行语句前已用完最大递归 100。

with FPRODUCTRANGETABLE as
(SELECT productDime.FPRODUCTID AS FPRODUCTID,COSTM.FMATERIALID
FROM V_CB_PROORDERINFO product
INNER JOIN T_CB_PROORDERDIME productDime ON product.FProductDimeId = productDime.FProductDimeId
INNER JOIN T_HS_OUTACCTG acctg ON product.FACCTGID = acctg.FId
INNER JOIN V_CB_CostMatterial COSTM ON product.FID = COSTM.FID
INNER JOIN T_BD_MATERIAL mat ON mat.fmaterialid=productDime.FPRODUCTID
where product.FENDINITKEY='1' and acctg.FDIMENSIONID=@FDIMENSIONID
and product.FACCTGID>=@FSTARTACCTGID and product.FACCTGID<=@FENDACCTGID
and mat.fnumber>=@FSTARTPRONUMBER and mat.fnumber<=@FENDPRONUMBER
and COSTM.FMATERIALID>0 and productDime.FPRODUCTID<>COSTM.FMATERIALID
UNION ALL
SELECT productDime.FPRODUCTID AS FPRODUCTID,COSTM.FMATERIALID
FROM V_CB_PROORDERINFO product
INNER JOIN T_CB_PROORDERDIME productDime ON product.FProductDimeId = productDime.FProductDimeId
INNER JOIN T_HS_OUTACCTG acctg ON product.FACCTGID = acctg.FId
INNER JOIN V_CB_CostMatterial COSTM ON product.FID = COSTM.FID
INNER JOIN FPRODUCTRANGETABLE TMP ON TMP.FMATERIALID=productDime.FPRODUCTID
where product.FENDINITKEY='1' and acctg.FDIMENSIONID=@FDIMENSIONID
and product.FACCTGID>=@FSTARTACCTGID and product.FACCTGID<=@FENDACCTGID
and COSTM.FMATERIALID>0
)

能远程看下问题吗？客户没有做过二开的
QQ:1661604226