StackOverflowDocumentation
.dbo
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
usp_Q949
Parameters
Name
Type
Mode
@UserId
int
IN
Definition
CREATE PROC [dbo].[usp_Q949] @UserId INT AS BEGIN /* Source: http://data.stackexchange.com/stackoverflow/query/949/what-is-my-accepted-answer-percentage-rate */ SELECT CASE WHEN (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) > 0 THEN (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) END AS AcceptedPercentage FROM Posts q INNER JOIN Posts a ON q.AcceptedAnswerId = a.Id WHERE a.OwnerUserId = @UserId AND a.PostTypeId = 2 END