UFN_AMPROIMPORT_DESIGNATION_ISACTIVE
Returns true if a designation is inactive.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DESIGNATIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_AMPROIMPORT_DESIGNATION_ISACTIVE
(
@DESIGNATIONID uniqueidentifier
)
returns bit
as
begin
if not exists (select ID from dbo.DESIGNATION where ID = @DESIGNATIONID and ISACTIVE = 1)
return 0;
return 1;
end