UFN_PROSPECTPLAN_GETSITES

Returns all sites for a given prospect plan.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN

Definition

Copy




            create function dbo.UFN_PROSPECTPLAN_GETSITES
            (
                @PROSPECTPLANID uniqueidentifier
            )
            returns table
            as
                return(
                    select
                        ID,
                        SITEID
                    from 
                        dbo.PROSPECTPLANSITE
                    where
                        PROSPECTPLANSITE.PROSPECTPLANID = @PROSPECTPLANID
                )