iam getting same average values when execute my stored procedure

Question

0.00/5 (No votes)

See more:

Hi
Iam Getting same average values when i execute my stored procedure.

i passing different TeamID's but Getting same Average values

this is my stored procedure :

SQL

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

Please give me a correct query for that.

Thank You

Posted 2-Sep-15 21:18pm

Member 11559509

Updated 2-Sep-15 23:46pm

Maciej Los

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-09-02T21:38:00

You aren't using the parameter value you pass in so I suspect it is returning the average values for all TeamId's - it's possible you want this:

SQL

SELECT AVG(VoteValue) AS [AverageVoteValue] 
FROM Vote 
WHERE datediff(day,getdate(),LastModifiedDateTime) <= 7
AND TeamID = @TeamID
ORDER BY AverageVoteValue

But without your data and a better idea of exactly what you want to get, it's difficult to be sure.

Member 11955429 · Answer 2 · 2015-09-02T21:37:00

SQL

based on you'r SP i'm excepecting you need to get avg values for Given Team ID

please check below Query

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



if it's not please write your requirement.

iam getting same average values when execute my stored procedure

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0