34,594
社区成员
发帖
与我相关
我的任务
分享
-- try
ALTER FUNCTION [dbo].[GetHistory](
@IssueNum int,
@Name varchar(100),
@NumSum int,
@Result varchar(50),
@History varchar(100)
)
RETURNS varchar(1024)
AS
BEGIN
DECLARE @tempID int,
@retValue varchar(100)
;with t as (
select row_number() over (order by IssueNum desc ) as Row, IssueNum ,R1
from NumsData
where IssueNum<@IssueNum and [Name]=@Name and NumSum =@NumSum and Result=@Result and History=@History
order by IssueNum desc
)
select @retValue=@retValue+R1
from t where row >=2 and Row <=4
return @retValue
END