UFN_BATCHWORKFLOWSTATE_GETTASKS
Returns a list of tasks for a given batch workflow state.
Return
| Return Type |
|---|
| nvarchar(2000) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHWORKFLOWSTATEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_BATCHWORKFLOWSTATE_GETTASKS(@BATCHWORKFLOWSTATEID uniqueidentifier)
returns nvarchar(2000)
as
begin
declare @retval nvarchar(2000);
select @retval = coalesce(@retval + ', ', '') + NAME from dbo.BATCHWORKFLOWTASK where BATCHWORKFLOWSTATEID = @BATCHWORKFLOWSTATEID;
return @retval
end;