spDelete_FundRaiserSolicitors

            CREATE  PROCEDURE [dbo].[spDelete_FundRaiserSolicitors]
            (
                @PKID int,
                @CurrentUsersID    int
            )
            AS

            begin transaction

                DELETE FROM [dbo].[FundRaiserSolicitors] WHERE [ID] = @PKID

                -- RealmTypeID{1} = VanityURL.ERealmType.Solicitor
                DELETE FROM [dbo].[VanityURL] WHERE [RealmID] = @PKID AND [RealmTypeID] = 1

            commit transaction