UFN_DELIVERYMETHOD_HASBEENUSED
Determines whether the given delivery method has ever been used to deliver tickets
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_DELIVERYMETHOD_HASBEENUSED
(
@ID uniqueidentifier
) returns bit
as
begin
if (select count(*) from dbo.SALESMETHODDELIVERYMETHOD where DELIVERYMETHODID = @ID) > 0
return 1;
else
return 0;
return 0;
end