备忘，搞不明白这是为什么

SELECT  CAST(0 AS BIT) AS fchoose ,
        a.fid AS fmaterialID ,
        a.fname AS fmaterialName ,
        a.fsize ,
        a.funit ,
        a.fclassname ,
        b.fsum AS fstoreQty
FROM    bas_materiel a
        INNER JOIN inv_materielsave b ON a.fid = b.fmate
WHERE   b.fsum > 0
        AND b.fmonth = ( SELECT MAX(fmonth)
                         FROM   inv_materielsave
                       )
        AND fclassname = '扁丝'
        AND ( fid LIKE '%x%'
              OR fname LIKE '%x%'
            )
        AND a.fsize LIKE '%x%';
 

 

/*上面的这种查询会报一个*/
消息 8624，级别 16，状态 21，第 1 行
内部查询处理器错误: 查询处理器无法生成查询计划。有关详细信息，请与客户支持服务部门联系。

修改后：

DECLARE @MaxMonth VARCHAR(20);
SELECT  @MaxMonth = MAX(fmonth)
FROM    inv_materielsave;
SELECT  @MaxMonth;
SELECT  CAST(0 AS BIT) AS fchoose ,
        a.fid AS fmaterialID ,
        a.fname AS fmaterialName ,
        a.fsize ,
        a.funit ,
        a.fclassname ,
        b.fsum AS fstoreQty
FROM    bas_materiel a
        INNER JOIN inv_materielsave b ON a.fid = b.fmate
WHERE   b.fsum > 0
        AND b.fmonth = ( @MaxMonth )
        AND fclassname = '油墨'
        AND ( a.fid LIKE '%r%'
              OR fname LIKE '%r%'
            );  

/*这个就是没有问题*/