UFN_SITEID_MAPFROM_STEWARDSHIPPLANSTEPID

             CREATE function dbo.UFN_SITEID_MAPFROM_STEWARDSHIPPLANSTEPID  
             (  
            @STEWARDSHIPPLANSTEPID uniqueidentifier  
             )   
                returns table
                as  
            return
            (
                select STEWARDSHIPPLANSITE.SITEID
                from dbo.STEWARDSHIPPLANSTEP
        inner join dbo.STEWARDSHIPPLAN on STEWARDSHIPPLAN.ID = STEWARDSHIPPLANSTEP.PLANID
                left join dbo.STEWARDSHIPPLANSITE on STEWARDSHIPPLANSITE.STEWARDSHIPPLANID = STEWARDSHIPPLAN.ID
                where STEWARDSHIPPLANSTEP.ID = @STEWARDSHIPPLANSTEPID
            );