[dbo].[Forum_Polls_PollGetOrphans]

(local) > DotNetNuke_Community > Stored Procedures > dbo.Forum_Polls_PollGetOrphans

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@ModuleID	int	4

SQL Script

CREATE PROCEDURE dbo.[Forum_Polls_PollGetOrphans] @ModuleID INT
AS
    SELECT  PollID
    FROM    dbo.Forum_Polls_Polls
    WHERE   ThreadID = -1
            AND CreatedDate < ( GetDate() - DATEPART(hh, 4) )
        AND ModuleID = @ModuleID

GO

Uses

[dbo].[Forum_Polls_Polls]
dbo