spParentPersonalPageData

Parameters

Parameter	Parameter Type	Mode
@ElementID	int	IN
@ParentID	int	IN
@ParentType	int	IN
@UserPersonalPageID	int	IN

Definition

Copy




    CREATE  PROCEDURE [dbo].[spParentPersonalPageData]
        (
            @ElementID int,
            @ParentID int,
            @ParentType int,
            @UserPersonalPageID int
        )
    AS
        SELECT     [ID],
            [ElementID],
            [ParentID],
            [ParentType],
            [XMLData]
            FROM PersonalPageData WHERE 
                [ParentID] = @ParentID
                AND [ElementID] = @ElementID
                AND [ParentType] = @ParentType
                AND (isnull([UserPersonalPageID],0) = @UserPersonalPageID or @UserPersonalPageID=0)

    RETURN