UFN_CONSTITUENT_GETPHONES_FORUPDATEBATCH

            CREATE function dbo.UFN_CONSTITUENT_GETPHONES_FORUPDATEBATCH(@CONSTITUENTID uniqueidentifier)
            returns table
            as return
                select 
                    P.[PHONETYPECODEID],
                    coalesce(P.[NUMBER], '') as NUMBER,
                    coalesce(P.[ISPRIMARY], cast(0 as bit)) as ISPRIMARY,
                    coalesce(P.[DONOTCALL], cast(0 as bit)) as DONOTCALL,
                    coalesce(P.[SEQUENCE], cast(0 as bit)) as SEQUENCE,
                    cast(0 as bit) as UPDATEHOUSEHOLD,
                    P.[COUNTRYID],
                    P.[SEASONALSTARTDATE],
                    P.[SEASONALENDDATE],
                    P.[STARTTIME],
                    P.[ENDTIME],
                    P.[STARTDATE],
                    P.[ENDDATE],
                    P.INFOSOURCECODEID,
                    P.ID as PHONEID,
                    coalesce(P.[DONOTTEXT], cast(0 as bit)) as DONOTTEXT,
                    ISNULL(P.INFOSOURCECOMMENTS,'') as INFOSOURCECOMMENTS
                from
                    dbo.[PHONE] P
                where
                    P.[CONSTITUENTID] = @CONSTITUENTID;