[dbo].[Forum_Avatar_Role

[dbo].[Forum_Avatar_Role_GetUserRoles]

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

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

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

SQL Script

CREATE PROCEDURE dbo.[Forum_Avatar_Role_GetUserRoles] ( @UserID INT )
AS
    SELECT  RoleID
    FROM    dbo.UserRoles
    WHERE   UserID = @UserID
            AND (EffectiveDate < GETDATE() OR EffectiveDate IS NULL)
            AND (ExpiryDate > GETDATE() OR ExpiryDate IS NULL)

GO

Uses

[dbo].[UserRoles]
dbo