spLoadRecord_VanityURL

    CREATE PROCEDURE [dbo].[spLoadRecord_VanityURL]
    (
    @PKID int
    )
    AS

    SELECT
    ID,
    RealmTypeID,
    RealmID,
    ClientUserID,
    PageID,
    TabID,
    VanityURL,
    TargetURL,
    ClientSitesID
    FROM VanityURL
    WHERE ID = @PKID

    RETURN