UFN_EVENTRESOURCE_GETRESOURCES

        CREATE function dbo.UFN_EVENTRESOURCE_GETRESOURCES
        (
          @EVENTID uniqueidentifier
        )
        returns table
        as return
            select EVENTRESOURCE.ID AS ID,
                         EVENTRESOURCE.RESOURCEID,
                         EVENTRESOURCE.QUANTITYNEEDED,
                         RESOURCE.ISPERTICKETITEM,
                         EVENTRESOURCE.PERTICKETQUANTITY
            from EVENTRESOURCE
                inner join RESOURCE on EVENTRESOURCE.RESOURCEID = RESOURCE.ID
            where EVENTRESOURCE.EVENTID = @EVENTID