StackOverflowDocumentation
.dbo
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
usp_Q947
Parameters
Name
Type
Mode
@UserId
int
IN
Definition
CREATE PROC [dbo].[usp_Q947] @UserId INT AS BEGIN /* Source: http://data.stackexchange.com/stackoverflow/query/947/my-comment-score-distribution */ SELECT Count(*) AS CommentCount, Score FROM Comments WHERE UserId = @UserId GROUP BY Score ORDER BY Score DESC END