UFN_SITEID_MAPFROM_EVENTSPONSORID

    CREATE FUNCTION DBO.UFN_SITEID_MAPFROM_EVENTSPONSORID  
    (  
      @EVENTSPONSORID UNIQUEIDENTIFIER  
    )   
    RETURNS TABLE
    AS  
    RETURN
    (
      SELECT EVENTSITE.SITEID
      FROM EVENTSPONSOR
      LEFT JOIN EVENTSITE ON EVENTSITE.EVENTID = EVENTSPONSOR.EVENTID
      WHERE EVENTSPONSOR.ID = @EVENTSPONSORID
    )