spTransactions_GetUnprocessedEventTransactionForUser

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


        AS
        BEGIN

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

        END