随便弄的，查询某个模板是否有6的模板项。

SELECT  *
FROM    ( SELECT    [TemplateCode] ,
                    CONVERT(CHAR, SUM(CASE WHEN TemplateItemCode = 11 THEN 11
                                           WHEN TemplateItemCode = 12
                                           THEN 1200
                                           WHEN TemplateItemCode = 13
                                           THEN 130000
                                           WHEN TemplateItemCode = 14
                                           THEN 14000000
                                           ELSE 0
                                      END)) AS a ,
                    CONVERT(CHAR, SUM(CASE WHEN TemplateItemCode = 1 THEN 1
                                           WHEN TemplateItemCode = 2 THEN 20
                                           WHEN TemplateItemCode = 3 THEN 300
                                           WHEN TemplateItemCode = 4 THEN 4000
                                           WHEN TemplateItemCode = 5
                                           THEN 50000
                                           WHEN TemplateItemCode = 6
                                           THEN 600000
                                           WHEN TemplateItemCode = 7
                                           THEN 7000000
                                           WHEN TemplateItemCode = 8
                                           THEN 80000000
                                           WHEN TemplateItemCode = 9
                                           THEN 900000000
                                           WHEN TemplateItemCode = 10
                                           THEN 10000000000
                                           ELSE 0
                                      END)) AS b
          FROM      [Mola_WareInfo_03].[dbo].[WI_WebWareDetailTemplateItem] t
          GROUP BY  t.TemplateCode
        ) AS tt
WHERE   b NOT  LIKE '%6%'

转载于:https://www.cnblogs.com/MoonbasaDesign/archive/2012/04/21/2461135.html