UFN_RE7TRIBUTE_GETTRIBUTEDESCRIPTION
Return
| Return Type |
|---|
| nvarchar(500) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | int | IN |
Definition
Copy
create function dbo.UFN_RE7TRIBUTE_GETTRIBUTEDESCRIPTION(@ID int)
returns nvarchar(500)
as
begin
return
(
select case when isnull([T].[DESCRIPTION], '') = '' then [C].[FULLNAME] + ' - ' + [TTC].[DESCRIPTION] else [C].[FULLNAME] + ' - ' + [TTC].[DESCRIPTION] + ' - ' + [T].[DESCRIPTION] end [IDENTIFIER]
from [dbo].[RE7_TRIBUTE] [T]
left outer join [dbo].[RE7_CONSTITUENT] [C] on [T].[CONSTITUENT_LOCALID] = [C].[LOCALID]
left outer join dbo.[RE7_TRIBUTETYPECODE] [TTC] on [T].[TYPECODE_LOCALID] = [TTC].[LOCALID]
where [T].[LOCALID] = @ID
)
end