34,590
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE [dbo].[dy]
@mm varchar(100),
@nn varchar(100),
@aa varchar(100)
as
Declare @sql varchar(MAX)
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 ) as cj
--Select @sql = @sql+' from cj where Name ='''+@mm+'''and 时间='''+@nn+''' GROUP by name,科室'
Select @sql = @sql+' from cj where 时间 between '''+@nn+'''and '''+@aa+''' and 科室='''+@mm+''' group by Name '
Exec (@sql)
ALTER PROCEDURE [dbo].[dy]
@mm varchar(100),
@nn varchar(100),
@aa varchar(100)
as
declare @sql varchar(MAX)
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 时间 between @nn and @aa) cj
Select @sql = @sql+' from cj where 时间 between '''+@nn+'''and '''+@aa+''' and 科室='''+@mm+''' group by Name '
Exec (@sql)