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
)