USP_DONORCHALLENGEENCUMBERPROCESS_GETCHALLENGES
Retrieves parameter settings for a given update donor challenge process parameter set.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SELECTIONID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DONORCHALLENGEENCUMBERPROCESS_GETCHALLENGES
(
@SELECTIONID uniqueidentifier = null
)
as
set nocount on;
select DONORCHALLENGE.ID
from dbo.DONORCHALLENGE
inner join dbo.UFN_IDSETREADER_GETRESULTS_GUID(@SELECTIONID) IDSET
on IDSET.ID = DONORCHALLENGE.ID
where DONORCHALLENGE.STATUSTYPECODE = 0;