在查询物料收发存汇总表的时候出现以下错误提示：
查询出现异常。不能将值 NULL 插入列 'FSECUNITID'，表 'AIS20151220164000.dbo.TMPC68FAC7DDE7E11E59F456C92BF0'；列不允许有 Null 值。UPDATE 失败。
语句已终止。
MERGE INTO TMPC68FAC7DDE7E11E59F456C92BF0 IT USING (
SELECT TP.FGUID,TMS.FSTOREURNUM AS FSTOREURNUM,TMS.FSTOREURNOM AS FSTOREURNOM,TM.FNUMBER AS FMATERIALNO,
ISNULL(TUB.FPRECISION,0) AS FBASEUNITPRE, ISNULL(TUS.FPRECISION,0) AS FSTOCKUNITPRE, ISNULL(TUA.FPRECISION,0) AS FSECUNITPRE,
TM.FNUMBER AS FMATERIALNUMBER,TML.FNAME AS FMATERIALNAME,TML.FSPECIFICATION AS FMATERIALMODEL,
TMB.FERPCLSID AS FERPCLSID,TMGL.FNAME AS FMATERIALGROUP, ISNULL(TMTL.FNAME,'') AS FMATERIALTYPENAME,
ISNULL(TMT.FCATEGORYID,0) AS FMATERIALTYPEID,TBS.FNUMBER AS FSTOCKNUMBER,TBSL.FNAME AS FSTOCKNAME,
CONVERT(NVARCHAR(1500), (CASE WHEN VFF100001.FNAME IS NOT NULL THEN 'OEM业务仓位值:' + CONVERT(NVARCHAR(100), VFF100001.FNAME) + ';' ELSE '' END) + (CASE WHEN VFF100002.FNAME IS NOT NULL THEN '成品仓:' + CONVERT(NVARCHAR(100), VFF100002.FNAME) + ';' ELSE '' END) + (CASE WHEN VFF100003.FNAME IS NOT NULL THEN '水性物料仓:' + CONVERT(NVARCHAR(100), VFF100003.FNAME) + ';' EL
周六的时候还是可以的，周一上班之后就成这样了
兰州：18394132721 QQ：2547741771
推荐阅读