报错信息，及调用语法如图，请指点哪里出错了，谢谢！此报错信息是在，数据预览的时候出现的。正确的存储过程调用应该如何写？脚本如下：CREATE PROCEDURE . (@KSRQ varchar (8),@JSRQ varchar (8)) ASBEGINCREATE TABLE #JSD ( BFJSD1_ZDRQ NVARCHAR (8), BFJSD1_JYBG NVARCHAR (20), BFJSD1_LSBH NVARCHAR (10), BFJSD1_SJDH NVARCHAR (20), BFJSD2_SL FLOAT, BFJSD2_JSSL FLOAT, BFJSD2_GBLS NVARCHAR (100), BFJSD2_C1B FLOAT, BFJSD2_C2B FLOAT, BFJSD2_C3B FLOAT, BFJSD1_BZ NVARCHAR (100), BFJSD1_DWBH NVARCHAR (30), BFJSD2_DJ FLOAT, BFJSD2_JE FLOAT ) INSERT INTO #JSD (BFJSD1_ZDRQ,BFJSD1_JYBG,BFJSD1_LSBH,BFJSD1_SJDH,BFJSD2_SL,BFJSD2_JSSL,BFJSD2_GBLS,BFJSD2_C1B,BFJSD2_C2B,BFJSD2_C3B,BFJSD1_BZ,BFJSD1_DWBH,BFJSD2_DJ,BFJSD2_JE)SELECT BFJSD1_ZDRQ,BFJSD1_JYBG,BFJSD1_LSBH,BFJSD1_SJDH,BFJSD2_SL,BFJSD2_JSSL,BFJSD2_GBLS,BFJSD2_C1B,BFJSD2_C2B,BFJSD2_C3B,BFJSD1_BZ,BFJSD1_DWBH,BFJSD2_DJ,BFJSD2_JEFROM BFJSD1,BFJSD2WHERE BFJSD1_LSBH=BFJSD2_LSBHAND (BFJSD1_ZDRQ>=@KSRQAND BFJSD1_ZDRQ<=@JSRQ)CREATE TABLE #JYBG ( ZJJYBG1_SJDH NVARCHAR (20), ZJJYBG3_LSBH NVARCHAR (10), SCSF FLOAT, SCZZ FLOAT ) INSERT INTO #JYBG (ZJJYBG1_SJDH,ZJJYBG3_LSBH,SCSF,SCZZ)SELECT DISTINCT ZJJYBG1_SJDH,ZJJYBG3_LSBH,convert(float,MAX(CASE WHEN ZJJYBG3_XMBH='01' THEN ZJJYBG3_JYSJ END)) SCSF,convert(float,MAX(CASE WHEN ZJJYBG3_XMBH='02' THEN ZJJYBG3_JYSJ END)) SCZZFROM ZJJYBG1,ZJJYBG3WHERE (ZJJYBG3_XMBH='01' OR ZJJYBG3_XMBH='02')AND ZJJYBG1_SJDH IN (SELECT BFJSD1_JYBG FROM #JSD)AND ZJJYBG1_LSBH=ZJJYBG3_LSBHGROUP BY ZJJYBG1_SJDH,ZJJYBG3_LSBHCREATE TABLE #GBD ( BFGBGL_LYDH NVARCHAR (20), BFGBD_LSBH NVARCHAR (10), BFGBD_SJDH NVARCHAR (20), BFGBD_KZ FLOAT, BFGBD_CLPH NVARCHAR (30) )INSERT INTO #GBD (BFGBGL_LYDH,BFGBD_LSBH,BFGBD_SJDH,BFGBD_KZ,BFGBD_CLPH)SELECT BFGBGL_LYDH,BFGBD_LSBH,BFGBD_SJDH,BFGBD_KZ,BFGBD_CLPHFROM BFGBD,BFGBGLWHEREBFGBD_LSBH=BFGBGL_LSBHAND BFGBD_LJBM='CGGBD'AND BFGBD_WLBH='010100001'AND BFGBD_LSBH IN (SELECT BFJSD2_GBLS FROM #JSD )CREATE TABLE #RKD ( KCRKD1_DJRQ NVARCHAR (8), KCRKD1_LSBH NVARCHAR (10), KCRKD1_SJDH NVARCHAR (20), KCRKD1_CKBH NVARCHAR (20), KCRKD2_GBDLS NVARCHAR (10), KCRKD2_SSSL FLOAT )INSERT INTO #RKD (KCRKD1_DJRQ,KCRKD1_LSBH,KCRKD1_SJDH,KCRKD1_CKBH,KCRKD2_GBDLS,KCRKD2_SSSL)SELECT DISTINCT KCRKD1_DJRQ,KCRKD1_LSBH,KCRKD1_SJDH,KCRKD1_CKBH,KCRKD2_GBDLS,KCRKD2_SSSLFROM KCRKD1,KCRKD2 WHERE KCRKD1_LSBH=KCRKD2_LSBHAND KCRKD2_GBDLS IN (SELECT BFGBD_LSBH FROM #GBD)CREATE TABLE #YMRKTJ ( BFGBD_CLPH NVARCHAR (30), LSCKZD_CKMC NVARCHAR (40), BFJSD1_DWBH NVARCHAR (30), BFJSD1_BZ NVARCHAR (100), BFJSD1_ZDRQ NVARCHAR (8), BFJSD1_JYBG NVARCHAR (20), BFJSD1_SJDH NVARCHAR (20), BFGBGL_LYDH NVARCHAR (20), BFGBD_SJDH NVARCHAR (20), KCRKD1_DJRQ NVARCHAR (8), KCRKD1_SJDH NVARCHAR (20), YSSL FLOAT, BFJSD2_JSSL FLOAT, BFJSD2_C1B FLOAT, BFJSD2_C2B FLOAT, BFJSD2_C3B FLOAT, BFJSD2_DJ FLOAT, BFJSD2_JE FLOAT, SCSF FLOAT, SCZZ FLOAT ) INSERT INTO #YMRKTJ(BFGBD_CLPH,LSCKZD_CKMC,BFJSD1_DWBH,BFJSD1_BZ, BFJSD1_ZDRQ,BFJSD1_JYBG, BFJSD1_SJDH,BFGBGL_LYDH,BFGBD_SJDH,KCRKD1_DJRQ,KCRKD1_SJDH,YSSL,BFJSD2_JSSL, BFJSD2_C1B, BFJSD2_C2B, BFJSD2_C3B, BFJSD2_DJ, BFJSD2_JE, SCSF, SCZZ)SELECT BFGBD_CLPH,LSCKZD_CKMC, BFJSD1_DWBH, BFJSD1_BZ, BFJSD1_ZDRQ, BFJSD1_JYBG, --BFJSD1_LSBH, BFJSD1_SJDH, BFGBGL_LYDH,BFGBD_SJDH, KCRKD1_DJRQ, KCRKD1_SJDH,BFJSD2_SL+BFGBD_KZ AS YSSL, BFJSD2_JSSL, BFJSD2_C1B, BFJSD2_C2B, BFJSD2_C3B, BFJSD2_DJ, BFJSD2_JE, SCSF, SCZZFROM #JSD,#JYBG,#GBD,#RKD,LSCKZD,ZWWLDWWHERE LSCKZD_CKBH=KCRKD1_CKBHAND BFGBD_LSBH=BFJSD2_GBLSAND BFJSD1_JYBG=ZJJYBG1_SJDHAND KCRKD2_GBDLS=BFGBD_LSBH AND ZWWLDW_DWBH=BFJSD1_DWBH SELECT BFGBD_CLPH AS 车辆牌号, LSCKZD_CKMC AS 仓库名称,BFJSD1_DWBH AS 客户编号, BFJSD1_BZ AS 合同客户, BFJSD1_ZDRQ AS 结算日期, BFJSD1_JYBG AS 报告单号, BFJSD1_SJDH AS 结算单号, BFGBGL_LYDH AS 到货单号, BFGBD_SJDH AS 过磅单号, KCRKD1_DJRQ AS 入库日期, KCRKD1_SJDH AS 入库单号, YSSL AS 应收数量, BFJSD2_JSSL AS 实收数量, BFJSD2_C1B AS 扣水数量, BFJSD2_C2B AS 扣杂数量, BFJSD2_C3B AS 扣生霉粒, BFJSD2_DJ AS 单价, BFJSD2_JE AS 结算金额, SCSF AS 实测水分, SCZZ AS 实测杂质FROM #YMRKTJORDER BY BFJSD1_SJDHEND
