UFN_SITEID_MAPFROM_VOLUNTEERID

   create function dbo.UFN_SITEID_MAPFROM_VOLUNTEERID  
   (  
    @VOLUNTEERID uniqueidentifier  
   )   
   returns table
   as  
    return
        (
        select CONSTITUENTSITE.SITEID
        from dbo.CONSTITUENT with (nolock)
        left outer join dbo.CONSTITUENTSITE with (nolock)
            on CONSTITUENT.ID = CONSTITUENTSITE.CONSTITUENTID
        where CONSTITUENT.ID = @VOLUNTEERID
        )