UFN_EMAILJOB_HASRECIPIENTS
Indicates whether or not an email job has any recipients.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | int | IN |
Definition
Copy
create function dbo.UFN_EMAILJOB_HASRECIPIENTS(@ID int)
returns bit
with execute as caller
as begin
declare @HASRECIPIENTS bit = 0
select top 1 @HASRECIPIENTS = 1 from dbo.EmailJob_Recipient EJR where EJR.EmailJobID = @ID
return @HASRECIPIENTS
end