fnTransactions_GetUnprocessedPollResults

CREATE   function [dbo].[fnTransactions_GetUnprocessedPollResults](@PollID int)
returns table as

return (

SELECT top 100 percent 
        spa.ID as 'PollAnswerID', 
        spa.Answer, 
        spr.DateAdded,
        dbo.fnGetRaisersEdgeRecordIDFromLinkedUserID(spr.ClientUsersID) as 'RERecordID', 
        cu.FirstName, 
        cu.LastName
FROM dbo.SitePolls sp 
            INNER JOIN SitePollAnswers spa ON
                spa.SitePollsID = sp.ID
            INNER JOIN SitePollResults spr ON
                spr.SitePollAnswersID = spa.ID
            LEFT OUTER JOIN ClientUsers cu ON 
                cu.ID = spr.ClientUsersID
WHERE sp.ID = @PollID  
    and spr.processed_date is null
order by spa.Answer, cu.FirstName, cu.LastName

)