110,571
社区成员
发帖
与我相关
我的任务
分享
[ID] [int] IDENTITY(1,1) NOT NULL,
[EmpID] [int] NULL,
[EmpName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[EmpNum] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[EmpDept] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Manager] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[Context] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL,
[Score] [float] NULL,
[Date] [datetime] NULL,
[DealDept] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ManageMent] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[IsAdd] [bit] NULL,
[InDate] [datetime] NULL,
[Result] [varchar](max) COLLATE Chinese_PRC_CI_AS NULL
select *,totalW=sum(Score) OVER (partition BY Score.[EmpName]) from Score left join (select ID,totalM=sum(Score) OVER (partition BY [EmpName]) from Score where IsAdd='" + state + "' and Date between '" + barEditItem5.EditValue + "' and '" + barEditItem6.EditValue + "') as tb on Score.ID=tb.ID where Date between '" + barEditItem1.EditValue + "' and '" + barEditItem2.EditValue + "' and IsAdd='" + state + "' order by Manager,EmpDept