在执行存储过程时获得相同的平均值

本文关键字：平均值 执行 存储过程 | 更新日期: 2023-09-27 18:11:09

当我执行存储过程时，我得到相同的平均值。

我正在传递不同的TeamID，但获得相同的平均值

存储过程: 

GO
/****** Object: StoredProcedure [dbo].[uspGetVote] Script Date: 9/3/2015 12:40:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[uspGetVote](@TeamID INT)
AS
BEGIN

select avg(VoteValue) as [AverageVoteValue] from Vote where datediff(day,getdate(),LastModifiedDateTime) <= 7 Group By TeamID order by AverageVoteValue
END

请给我一个正确的查询

Thank You

在执行存储过程时获得相同的平均值

我猜你要找的是:

GO
/****** Object: StoredProcedure [dbo].[uspGetVote] Script Date: 9/3/2015 12:40:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[uspGetVote](@TeamID INT)
AS
BEGIN

SELECT AVG(VoteValue) AS [AverageVoteValue] FROM Vote 
WHERE DATEDIFF(day,getdate(),LastModifiedDateTime) <= 7 
AND TeamId = @TeamID
GROUP BY TeamId
ORDER BY AverageVoteValue
END
相关文章：