Stored Procedures [dbo].[Forum_Members_GetOnline]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@PortalIDint4
SQL Script


CREATE PROCEDURE dbo.[Forum_Members_GetOnline] @PortalID INT
AS
    SELECT  U.[UserID],
            [PostCount],
            [EnableDisplayInMemberList],
            [EnableOnlineStatus],
            [EnablePM],
            U.[PortalID],
            [FirstName],
            [LastName],
            [Email],
            [Username],
            [PostCount],
            ( SELECT    COUNT(UserID)
              FROM      dbo.Forum_vw_ForumUsers
            ) AS TotalRecords
    FROM    dbo.UsersOnline UO
            INNER JOIN dbo.Forum_vw_ForumUsers U ON UO.UserID = U.UserID
    WHERE   U.PortalID = @PortalID

GO
Uses