UFN_SECONDARYFUNDRAISER_VALIDCONSTITUENT
Validates the start and end dates of a secondary fundraiser on a prospect plan.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SECONDARYFUNDRAISERID | uniqueidentifier | IN | |
| @PROSPECTPLANID | uniqueidentifier | IN | |
| @FUNDRAISERID | uniqueidentifier | IN | |
| @DATEFROM | datetime | IN | |
| @DATETO | datetime | IN |
Definition
Copy
CREATE function dbo.UFN_SECONDARYFUNDRAISER_VALIDCONSTITUENT
(
@SECONDARYFUNDRAISERID uniqueidentifier,
@PROSPECTPLANID uniqueidentifier,
@FUNDRAISERID uniqueidentifier,
@DATEFROM datetime,
@DATETO datetime
)
returns bit
with execute as caller
as begin
if @SECONDARYFUNDRAISERID is null
return 1;
if exists (
select top 1
ID
from
dbo.SECONDARYFUNDRAISER
where
FUNDRAISERID = @FUNDRAISERID and
ID <> @SECONDARYFUNDRAISERID and
PROSPECTPLANID = @PROSPECTPLANID and
(
( DATETO between @DATEFROM and @DATETO) or
(@DATETO between DATEFROM and DATETO) or
( DATEFROM between @DATEFROM and @DATETO) or
(@DATEFROM between DATEFROM and DATETO) or
( DATEFROM is null and @DATEFROM <= DATETO) or
(@DATEFROM is null and DATEFROM <= @DATETO) or
( DATETO is null and @DATETO >= DATEFROM) or
(@DATETO is null and DATETO >= @DATEFROM) or
(@DATEFROM is null and DATEFROM is null) or
(@DATETO is null and DATETO is null) or
(@DATEFROM is null and @DATETO is null) or
( DATEFROM is null and DATETO is null)
)
)
return 0;
return 1;
end