spTransactions_GetLatestUnprocessedVolunteerTransaction

            CREATE PROCEDURE dbo.spTransactions_GetLatestUnprocessedVolunteerTransaction
                (
                @ClientID int,
                @UserID int
                )
            AS
            BEGIN
                SELECT TOP 1 VolunteerTransactions.ID, VolunteerTransactions.XMLObjectData
                FROM dbo.VolunteerTransactions 
                JOIN dbo.SiteContent ON VolunteerTransactions.VolunteerOpID = SiteContent.ID
                WHERE SiteContent.ClientSitesID = @ClientID AND VolunteerTransactions.AddedBy = @UserID
                  AND VolunteerTransactions.ProcessedDate IS NULL AND VolunteerTransactions.IsDeleted = 0
                ORDER BY VolunteerTransactions.DateAdded DESC
            END