UFN_SITEID_MAPFROM_GRANTORID

           create function dbo.UFN_SITEID_MAPFROM_GRANTORID  
           (  
            @GRANTORID 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 = @GRANTORID
                )