UFN_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETSTEPPARTICIPANTS
Returns all stepparticipants for a given batch stewardship plan step update record.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHSTEWARDSHIPPLANSTEPUPDATEID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETSTEPPARTICIPANTS
(
@BATCHSTEWARDSHIPPLANSTEPUPDATEID uniqueidentifier
)
returns table
as
return
(
select
[BATCHSTEWARDSHIPPLANSTEPUPDATESTEPPARTICIPANT].ID,
[BATCHSTEWARDSHIPPLANSTEPUPDATESTEPPARTICIPANT].CONSTITUENTID
from
dbo.BATCHSTEWARDSHIPPLANSTEPUPDATESTEPPARTICIPANT
where
[BATCHSTEWARDSHIPPLANSTEPUPDATESTEPPARTICIPANT].BATCHSTEWARDSHIPPLANSTEPUPDATEID = @BATCHSTEWARDSHIPPLANSTEPUPDATEID
);