UFN_RECURRINGGIFT_GETMISSINGINSTALLMENTS
Returns an xml list of all installments that are missing from the RG installment table for a given recurring gift.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_RECURRINGGIFT_GETMISSINGINSTALLMENTS(
@ID uniqueidentifier
)
returns @INSTALLMENTS table (DATE date)
as begin
insert into @INSTALLMENTS(DATE) select DATE from dbo.UFN_RECURRINGGIFT_GETMISSINGINSTALLMENTS_ASOFDATE(@ID, getdate());
return;
end