fnTransactions_GetUnprocessedGiftsForClientRange
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientID | int | IN | |
| @StartLetter | nvarchar(1) | IN | |
| @EndLetter | nvarchar(1) | IN | |
| @Within | bit | IN |
Definition
Copy
CREATE function dbo.fnTransactions_GetUnprocessedGiftsForClientRange(@ClientID int,@StartLetter as nvarchar(1), @EndLetter as nvarchar(1), @Within as bit)
returns table as
return (
select * from dbo.fnTransactions_GetUnprocessedGiftsForClient(@ClientID) gifts
where
(
(@within=1 and (left(gifts.LastName,1) between @StartLetter and @EndLetter))
or
(@within=0 and ((left(gifts.LastName,1) not between @StartLetter and @EndLetter) or gifts.lastname is null))
)
)