UFN_SITEID_MAPFROM_STEWARDSHIPPLANID

Maps a STEWARDSHIPPLANID to multiple SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@STEWARDSHIPPLANID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_SITEID_MAPFROM_STEWARDSHIPPLANID(@STEWARDSHIPPLANID uniqueidentifier)   
            returns table
            as  
            return
                select STEWARDSHIPPLANSITE.SITEID   
                from dbo.STEWARDSHIPPLAN
                left outer join dbo.STEWARDSHIPPLANSITE on STEWARDSHIPPLANSITE.STEWARDSHIPPLANID = STEWARDSHIPPLAN.ID
                where STEWARDSHIPPLAN.ID = @STEWARDSHIPPLANID;