spGetClientUserHomePage

        CREATE PROCEDURE dbo.spGetClientUserHomePage
            (
            @ClientUserID int
            )
            AS
            BEGIN

            SELECT TOP 1 SitePageID, frs.ID 'SolicitorID'
            FROM
            FundRaiserPages frp
            INNER JOIN UserPersonalPages upp ON upp.FundRaiserPageID = frp.ID
            INNER JOIN FundRaiserSolicitors frs ON frs.ID = upp.ParentID
            WHERE frs.ClientUsersID = @ClientUserID

            END