如何显示特定的id数据usig pivot？

本文介绍了如何显示特定的id数据usig pivot？的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我是水晶报道的新手。实际上我通过使用下面的查询显示所有细节，但我想只显示特定的ID或特定的人通过修改下面的查询帮助我

hi i am new to crystal report . Actually i am display all details by using below query but i want to display only for particular id or particular person help me by modifing below query

Declare @year varchar(max)='' SELECT @year= Stuff((SELECT ', [' + cast(s as varchar(max))+']' FROM (SELECT DISTINCT DATEPART(YYYY,Sdate) as s FROM dbo.StudDet ) x For XML PATH ('')),1,1,'') exec('select Months,'+@year+' from ( select cast(DATEPART(MONTH,Sdate) as varchar(max)) as Months,Score, DATEPART(year,Sdate) as st from dbo.StudDet ) x pivot ( max(Score) for st in('+@year+') )p ')

推荐答案

你需要在你的sql中添加一个 WHERE 子句，例如 You need to add a WHERE clause to your sql e.g. ... FROM dbo.StudDet WHERE ID=@inputID

注意我已经猜到了id的列名，并假设你在@inputId中传递了所需的ID

Note that I''ve had a guess at the column name for the id and assumed that you''re passing in the required ID in @inputId