spLoadRecord_PersonalizedContentData

Parameters

Parameter	Parameter Type	Mode
@SiteContentID	int	IN
@ParentID	int	IN
@ParentType	int	IN
@UserPageId	int	IN

Definition

Copy


CREATE  PROCEDURE [dbo].[spLoadRecord_PersonalizedContentData]
        (
            @SiteContentID int,
            @ParentID int,
            @ParentType int,
            @UserPageId int
        )
    AS
SELECT         pd.ID,
            pd.SiteContentID,
            pd.ParentID,
            pd.ParentType,
            pd.UserPageID,
            pd.XMLData,
            up.ClientUserId
            FROM PersonalizedContentData pd
            left join UserPages up on pd.UserPageID=up.ID 
            WHERE 
                [ParentID] = @ParentID
                AND [SiteContentID] = @SiteContentID
                AND [ParentType] = @ParentType
                AND [UserPageID] = @UserPageId
    RETURN