USP_REPORT_EVENTATTENDEE

            create procedure dbo.USP_REPORT_EVENTATTENDEE
            (
                @EVENTID uniqueidentifier 
            )
            as

            set nocount on;


            select 
                isnull(CONSTITUENT.NAME, 'Anonymous') as NAME,
                case
                    when CONSTITUENT.ID is null then '---'

                    when MEMBER.ID is null then 'No'
                    else 'Yes'
                end as MEMBER,
                PRICETYPECODE.[DESCRIPTION] + ' - ' + cast(count(TICKET.ID) as varchar) as TICKETS,
                SALESORDER.SEQUENCEID as ORDERNUMBER,
                case
                    when dbo.UFN_SALESORDER_GETBALANCE(SALESORDER.ID) = 0 then 'Yes'
                    else 'No'
                end as ORDERPAID,
                'http://www.blackbaud.com?SALESORDERID=' + CONVERT(nvarchar(36), SALESORDER.ID) SALESORDERURL,
                'http://www.blackbaud.com?CONSTITUENTID=' + CONVERT(nvarchar(36), CONSTITUENT.ID) CONSTITUENTURL
            from dbo.[EVENT]
            inner join dbo.SALESORDERITEMTICKET on SALESORDERITEMTICKET.EVENTID = [EVENT].ID
            inner join dbo.SALESORDERITEM on SALESORDERITEM.ID = SALESORDERITEMTICKET.ID
            inner join dbo.SALESORDER on SALESORDERITEM.SALESORDERID = SALESORDER.ID
            inner join dbo.PRICETYPECODE on SALESORDERITEMTICKET.PRICETYPECODEID = PRICETYPECODE.ID
            inner join dbo.TICKET on TICKET.SALESORDERITEMTICKETID = SALESORDERITEMTICKET.ID
            left outer join dbo.CONSTITUENT on SALESORDER.CONSTITUENTID = CONSTITUENT.ID
            left outer join dbo.MEMBER on MEMBER.CONSTITUENTID = CONSTITUENT.ID
            where [EVENT].ID = @EVENTID and not [EVENT].PROGRAMID is null
            group by CONSTITUENT.NAME, PRICETYPECODE.[DESCRIPTION], SALESORDER.SEQUENCEID, 
            SALESORDER.ID, CONSTITUENT.ID, MEMBER.ID