spTransactions_GetUnprocessedMembershipTransactionForUser

           CREATE PROCEDURE [dbo].[spTransactions_GetUnprocessedMembershipTransactionForUser]
    (        @UserID                 int)


        AS
        BEGIN

        SET NOCOUNT ON;
        SELECT XMLObjectData FROM MembershipTransactions WHERE (AddedByUserID=@UserID And processed_date Is NULL And Status = 1)

        END