Our Training Programs

All contents are copyright of their authors.

I want to get last 7day average vote values

I want to get last 7day average vote values

Sivakumar

11yAsked Sep 3, 2015, 1:27 AM792Visual Basic .NET

Hi,

I want to get the last 7day average vote values passing CardID and TeamID using stored procedure:

this is my table structure :

using Vote table to get last 7days average vote value based on last modified datetime.

thank you

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Sivakumar11y ago
I want to print average values decimal or float
Pradeep11y ago
100% it will work. try it .....

select avg(VoteValue) as [AverageVoteValue] from Vote where LastModifiedDateTime in
(select top 7 LastModifiedDateTime from Vote where TeamID=@teamID and CardID=@cardID order by LastModifiedDateTime desc)

you just Pass @teamID & @cardID parameters that's it.
Sivakumar11y ago
No this is not working, when i execute stored procedure then getting same average values.

please give me correct query for that
Pradeep11y ago
HI,
I hope it will help you....

select avg(VoteValue) as [AverageVoteValue] from Vote where datediff(day,getdate(),lastModificationDateTime) <= 7 groupBy TeamID