34,590
社区成员
发帖
与我相关
我的任务
分享
DECLARE @sql NVARCHAR(MAX);
--用unicode
SET @sql = 'Select Name as 姓名';
SELECT @sql = @sql + ',MAX(case 时间 when ''' + 时间
+ ''' then Result end) [' + 时间 + CHAR(10) + '周'
+ RTRIM(DATEPART(dw , DATEADD(dd , -1 , 时间))) + ']'
from (select distinct convert(varchar(10),时间,120) as 时间 from cj WHERE name=@mm AND 科室=@nn) as cj
Select @sql = @sql+' from cj where name='''+@mm+'''and 科室='''+@nn+''' group by name'
from (select distinct convert(varchar(10),时间,120) as 时间 from cj WHERE name=@mm AND 科室=@nn) as cj
Select @sql = @sql+' from cj where name='''+@mm+'''and 科室='''+@nn+''' group by name'