UFN_ASSIGNLETTERCODESPROCESS_VALIDATELETTEREXISTS
Validates whether or not at least one letter is present in the given assign letter process.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ASSIGNLETTERCODESPROCESSID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_ASSIGNLETTERCODESPROCESS_VALIDATELETTEREXISTS
(
@ASSIGNLETTERCODESPROCESSID uniqueidentifier = null
)
returns bit
as
begin
declare @COUNT int;
declare @VALID bit;
if @ASSIGNLETTERCODESPROCESSID is null
begin
select
@COUNT = count(LETTERCODE.ID)
from
dbo.LETTERCODE
where
LETTERCODE.ISACTIVE = 1;
end
else
begin
select
@COUNT = count(PLC.ID)
from
dbo.ASSIGNLETTERCODESPROCESSLETTERCODES PLC
inner join
dbo.LETTERCODE on PLC.LETTERCODEID = LETTERCODE.ID
where
ASSIGNLETTERCODESPROCESSID = @ASSIGNLETTERCODESPROCESSID
and LETTERCODE.ISACTIVE = 1;
end
if @COUNT = 0
set @VALID = 0;
else
set @VALID = 1;
return @VALID;
end