UFN_PROSPECTRESEARCHTEMPLATE_GETSECTIONS

Returns all sections for a Prospect Research Report.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTRESEARCHTEMPLATEID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PROSPECTRESEARCHTEMPLATE_GETSECTIONS(@PROSPECTRESEARCHTEMPLATEID uniqueidentifier)
            returns table
            as
            return
            (
                select
                    ID,
                    SECTIONCODE,
          SEQUENCE
                from
                    dbo.PROSPECTRESEARCHTEMPLATESECTION
                where
                    PROSPECTRESEARCHTEMPLATEID = @PROSPECTRESEARCHTEMPLATEID
            );