UFN_DESIGNATIONLEVELFINANCIALINFO_VALIDTIMEPERIOD
Determines whether the date range for this financial information has already been used.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DESIGNATIONLEVELID | uniqueidentifier | IN | |
| @STARTDATE | datetime | IN | |
| @ENDDATE | datetime | IN |
Definition
Copy
create function dbo.UFN_DESIGNATIONLEVELFINANCIALINFO_VALIDTIMEPERIOD
(
@DESIGNATIONLEVELID uniqueidentifier,
@STARTDATE datetime,
@ENDDATE datetime
)
returns bit
with execute as caller
as
begin
declare @DUPLICATECOUNT int;
select
@DUPLICATECOUNT = count(ID)
from
dbo.DESIGNATIONLEVELFINANCIALINFO
where
DESIGNATIONLEVELID = @DESIGNATIONLEVELID and
(
( ENDDATE between @STARTDATE and @ENDDATE) or
(@ENDDATE between STARTDATE and ENDDATE) or
( STARTDATE between @STARTDATE and @ENDDATE) or
(@STARTDATE between STARTDATE and ENDDATE)
)
if (@DUPLICATECOUNT <= 1)
return 1;
return 0;
end