UFN_ELEMENTBUILDNAME
This function returns element name and short ID.
Return
| Return Type |
|---|
| nvarchar(203) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @PDACCOUNTSTRUCTUREID | uniqueidentifier | IN | |
| @QUERYID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_ELEMENTBUILDNAME(@ID uniqueidentifier, @PDACCOUNTSTRUCTUREID uniqueidentifier, @QUERYID uniqueidentifier)
returns nvarchar(203)
with execute as caller
as begin
declare @RETURN nvarchar(203) = null
select @RETURN = PDACCOUNTSTRUCTURE.DESCRIPTION from dbo.PDACCOUNTSTRUCTURE where ID = @PDACCOUNTSTRUCTUREID
if @ID is not null
select @RETURN = @RETURN + ' - ' + SHORTDESCRIPTION from dbo.PDACCOUNTSEGMENTVALUE where ID = @ID;
else if @QUERYID is not null
set @RETURN = @RETURN +' - ' + dbo.UFN_IDSET_GETNAME(@QUERYID)
else
set @RETURN = @RETURN + ' - All records'
return @RETURN
end