UFN_SITEID_MAPFROM_CONSTITUENTINTERACTIONID

Maps an CONSTITUENTINTERACTIONID to a SITEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTINTERACTIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SITEID_MAPFROM_CONSTITUENTINTERACTIONID(
                @CONSTITUENTINTERACTIONID uniqueidentifier
            )
            returns @SITES table (SITEID uniqueidentifier)
            as
            begin
                insert into @SITES(SITEID)
                select SITEID
                from dbo.UFN_SITEID_MAPFROM_INTERACTIONID(@CONSTITUENTINTERACTIONID)                        

                return;
            end