通过数据库存储过程动态表头制作.docxVIP

这段代码在eTangent_AMS中….ALTERPROCEDURE[dbo].[ExpertGiveGraded]@PrizeGroupIDint,@AchievementFormintASBEGINdeclare@sql1nvarchar(500)declare@sql2nvarchar(500)declare@sql3nvarchar(max)declare@sql4nvarchar(500)declare@sql5nvarchar(max)declare@sql6nvarchar(500)declare@sql7nvarchar(500)declare@PartakeExpertNumintDeclare@GetprizeNumintset@sql1=set@sql2=set@sql3=set@sql4=set@sql5=set@sql6=set@sql7=set@PartakeExpertNum=0select@GetprizeNum=count(Expert.Name)fromAchievementjoinParticipantsonParticipants.AchievementID=Achievement.AchievementIDjoinmarkonmark.AchievementID=Achievement.AchievementIDjoinExpertonExpert.ExpertID=mark.ExpertIDwhereMark.PrizeRankRecommended=-1 andPrizeGroupID=@PrizeGroupIDset@sql1=select Achievement.FirstEvaluationNo as [初评编号],Achievement.HostName as [申报人姓名],WorkUnitName as [工作单位],TitleName as [职称],DutyName as [职务],Achievement.AchievementName as [成果名称],(Achievement.SerialNumber +Achievement.Publisher +Achievement.PublicationDate) as [成果发表期刊、出版单位名称以及成果发表、出版时间]select@PartakeExpertNum=@PartakeExpertNum+1,@sql2=@sql2+,CONVERT(decimal(18,2), Score.[+CAST([ExpertID]ASnvarchar(256))+评分]) AS [+[Name]+评分],@sql4=@sql4+,sum(case ExpertID when +cast(ExpertIDasnvarchar(5))+ then TotalScore end) as [+CAST([ExpertID]ASnvarchar(256))+评分]fromExpertwhereExpertIDin(selectExpertIDfromPrizeGroupExpertwherePrizeGroupID=@PrizeGroupIDandIsPartake=1)SELECT@sql7=@sql7+,isnull(sum(case PrizeRankRecommended when +cast(PropertyValueasnvarchar(50))+ then countofprise end),0) as 推荐+cast(PropertyMeaningasnvarchar(50))+个数,@sql6=@sql6+, newprisecount.推荐+PropertyMeaning+个数FROM (SELECTDISTINCTPropertyValue,PropertyMeaningfrommarkinnerjoinPropertyMappingonmark.PrizeRankRecommended=PropertyMapping.PropertyValuewhereachievementidin(selectAchievementIDfromAchievementwherePrizeGroupID=@PrizeGroupID)andPropertyMapping.PropertyName=PrizeRankRecommendedandPropertyMapping.PropertyValue!=-1)ASAset@sql3=,Convert(decimal(18,2), Achievement.AverageScore) as 平均分,isnull(prisecount.countofall,0)-isnull(no