随便弄的，查询某个模板是否有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 ttWHERE   b NOT  LIKE '%6%'

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