Stored Procedure Properties
Name | Value |
---|---|
Owner | dbo |
Created | 2004-05-31 |
Startup | False |
Encrypted | False |
Creation Options
Name | Value |
---|---|
QUOTED_IDENTIFIER | ON |
ANSI_NULLS | ON |
Parameters
Name | DataType | Length | Type |
---|
Total: 0 parameter(s)
SQL
SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO --exec Statistics_GetMostActiveModerators create procedure Statistics_GetModerationActions AS SELECT DISTINCT Description, TotalActions = (SELECT Count(ModerationAction) FROM ModerationAudit M2 WHERE M2.ModerationAction = M.ModerationAction) FROM ModerationAudit M, ModerationAction A WHERE M.ModerationAction = A.ModerationAction ORDER BY TotalActions DESC GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO