Question

当结果能够有数量可变的栏目时,你如何将特殊产品的产出列入表格?

本次级工作方案列出了各栏数可能各不相同的表格。我需要把结果列入一个温和表,以便我能够用它来盘问报告。我如何建立一个能够处理SP产出的表格?

 DECLARE @cols AS VARCHAR(MAX),
 @query  AS VARCHAR(MAX); 

 SET @cols = STUFF((SELECT distinct  ,  + QUOTENAME(c.question) 
        FROM temp_SURVEY_DATA c
        FOR XML PATH(  ), TYPE
        ).value( . ,  VARCHAR(MAX) ) ,1,1,  )

 set @query =   SELECT responseid, moduleid, responsedatetime,   + @cols +   from 
        (select question, response, responsedatetime, responseid, moduleid
            from temp_SURVEY_DATA) x
        pivot 
        ( max(response)
            for question IN(  + @cols +  ) ) p  

          execute(@query)

Answer 1

a. 专门为此类物品使用静态表格,并在表格中添加结果,而不是将浏览量退回给电线人:

DECLARE @cols AS VARCHAR(MAX),
        @query  AS VARCHAR(MAX); 

 SET @cols = STUFF((SELECT distinct  ,  + QUOTENAME(c.question) 
        FROM temp_SURVEY_DATA c
        FOR XML PATH(  ), TYPE
        ).value( . ,  VARCHAR(MAX) ) ,1,1,  );

EXECUTE ( IF OBJECT_ID(  temp_SURVEY_DATA_pivoted  ) IS NOT NULL
  DROP TABLE temp_SURVEY_DATA_pivoted );

set @query =   SELECT responseid, moduleid, responsedatetime,   + @cols +  
  INTO temp_SURVEY_DATA_pivoted
  from 
        (select question, response, responsedatetime, responseid, moduleid
            from temp_SURVEY_DATA) x
        pivot 
        ( max(response)
            for question IN(  + @cols +  ) ) p  

          execute(@query)

或者在显示数据之前,在其他地方使用动态文字时放弃这种说法。

友情链接