sql - 如何使每月动态？下面的脚本是一月和二月的硬编码

Question

WITH ctetable AS 
(
    SELECT DISTINCT 
        [site id],
        DATENAME(MONTH, [wcp_createddate]) AS MonthNames
    FROM   
        [dbo].[getsiteharveyballscores]
)
SELECT 
    *,
   january + february AS Combine,
   IIF((january + february) = 1
        AND february = 0, 'Drop', IIF((january + february) = 1
                                     AND february = 1, 'New', 'Continue')) AS Flag
FROM   
    (SELECT 
         monthnames,
         [site id] AS SiteId,
         [site id]
     FROM   
         ctetable) AS SourceTable
PIVOT
    (COUNT([site id])   
         FOR monthnames IN (january, february)) AS pivottable;     

标签： sqltsql