UFN_MEMBERSHIPLEVELCONTRIBUTIONEXPIRATIONDATERANGE_OVERLAP
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STARTDATE | UDT_MONTHDAY | IN | |
| @ENDDATE | UDT_MONTHDAY | IN | |
| @MEMBERSHIPLEVELCONTRIBUTIONID | uniqueidentifier | IN |
Definition
Copy
CREATE function [dbo].[UFN_MEMBERSHIPLEVELCONTRIBUTIONEXPIRATIONDATERANGE_OVERLAP](
@STARTDATE [dbo].[UDT_MONTHDAY],
@ENDDATE [dbo].[UDT_MONTHDAY],
@MEMBERSHIPLEVELCONTRIBUTIONID uniqueidentifier
)
returns bit
as
begin
declare @RESULTBIT bit = 1
if ( select count(*)
from [dbo].[MEMBERSHIPLEVELCONTRIBUTIONEXPIRATIONDATERANGE] dr
where dr.MEMBERSHIPLEVELCONTRIBUTIONID = @MEMBERSHIPLEVELCONTRIBUTIONID
AND
((@STARTDATE >= dr.STARTDATE and @STARTDATE < dr.ENDDATE)
or (@ENDDATE > dr.STARTDATE and @ENDDATE <= dr.ENDDATE))
) > 1
set @RESULTBIT = 0
return @RESULTBIT
end