UFN_DISBURSEMENTPROCESSTEMPLATE_FORMATS
Returns a comma separated listing of all the formats assigned to the disbursement process template
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DISBURSEMENTPROCESSTEMPLATEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_DISBURSEMENTPROCESSTEMPLATE_FORMATS
(
@DISBURSEMENTPROCESSTEMPLATEID uniqueidentifier = null
)
returns nvarchar(max)
with execute as caller
as begin
declare @DESC nvarchar(max);
select @DESC = Coalesce(@DESC + ', ', '') + F.NAME
from dbo.DISBURSEMENTFORMAT F
inner join dbo.DISBURSEMENTPROCESSTEMPLATEFORMAT P on P.DISBURSEMENTFORMATID = F.ID
where P.DISBURSEMENTPROCESSTEMPLATEID = @DISBURSEMENTPROCESSTEMPLATEID
order by F.NAME
set @DESC = ISNULL(@DESC, '');
return @DESC;
end