UFN_CONSTITUENT_GETPHONESWITHSEASONAL

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_CONSTITUENT_GETPHONESWITHSEASONAL(@CONSTITUENTID uniqueidentifier)
        returns table
        as return
        select
        ID,
        PHONETYPECODEID,
        NUMBER,
        ISPRIMARY,
        SEQUENCE,
        STARTTIME,
        ENDTIME,
        STARTDATE,
        COUNTRYID,
        SEASONALSTARTDATE,
        SEASONALENDDATE,
        [INFOSOURCECODEID],
        [INFOSOURCECOMMENTS]
        from
        dbo.PHONE
        where
        CONSTITUENTID=@CONSTITUENTID;