UFN_SIGNATURE_APPLICATIONSDESCRIPTION
Returns a comma separated string that lists all the application types for a signature
Return
| Return Type |
|---|
| nvarchar(max) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SIGNATUREID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SIGNATURE_APPLICATIONSDESCRIPTION(
@SIGNATUREID uniqueidentifier = null
)
returns nvarchar(max)
with execute as caller
as begin
declare @DESC nvarchar(max);
select @DESC = isnull(@DESC, '') + ', ' + SIGNATUREAPPLICATIONTYPE.TYPE
from dbo.SIGNATUREAPPLICATION
inner join dbo.SIGNATUREAPPLICATIONTYPE on SIGNATUREAPPLICATION.SIGNATUREAPPLICATIONTYPEID = SIGNATUREAPPLICATIONTYPE.ID
where SIGNATUREAPPLICATION.SIGNATUREID = @SIGNATUREID
order by SIGNATUREAPPLICATIONTYPE.SEQUENCE asc
set @DESC = substring(@DESC, 3, len(@DESC))
return @DESC
end