UFN_QUERY_PLEDGEREMINDERPROCESSEMAILOUTPUTSUMMARY

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@PARAMETERSETID uniqueidentifier IN

Definition

Copy


      CREATE function [dbo].[UFN_QUERY_PLEDGEREMINDERPROCESSEMAILOUTPUTSUMMARY]
            (
                @PARAMETERSETID uniqueidentifier = null
            )
        returns table
        as
        return
                (
  select  DISTINCT top(100) PERCENT  
                  CONSTITUENTLOOKUPID,
                  CONSTITUENTNAME,
                  ADDRESSEE,
                  SALUTATION,
                  CONTACT,    
          POSITION,
                  EMAILADDRESS
              from dbo.UFN_QUERY_PLEDGEREMINDERPROCESSEMAILOUTPUT(@PARAMETERSETID)
            order by CONSTITUENTLOOKUPID        
            )