UFN_MKTSEGMENTATION_ISAPPEALMAILING
Returns whether or not a marketing effort is an appeal mailing.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENTATION_ISAPPEALMAILING]
(
@ID uniqueidentifier
)
returns bit
as
begin
return (case when exists(select 1 from dbo.[APPEALMAILING] where [ID] = @ID) then 1 else 0 end);
end