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
)