UFN_NETCOMMUNITYDEFAULTCODEMAP_GETDONOTMAILCODE
Returns the solicit code used by the CMS to indicate a constituent shouldn't be sent mail.
Return
| Return Type |
|---|
| uniqueidentifier |
Definition
Copy
create function dbo.UFN_NETCOMMUNITYDEFAULTCODEMAP_GETDONOTMAILCODE()
returns uniqueidentifier
with execute as caller
as begin
-- do work here and return a value
declare @NOEMAILSOLICITCODEID uniqueidentifier
select top 1 @NOEMAILSOLICITCODEID=DONOTEMAILSOLICITCODEID
from NETCOMMUNITYDEFAULTCODEMAP
return @NOEMAILSOLICITCODEID
end