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