UFN_TRANSLATIONFUNCTION_SOLICITCODE_GETNAME
Return
| Return Type |
|---|
| nvarchar(1024) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_TRANSLATIONFUNCTION_SOLICITCODE_GETNAME(@ID uniqueidentifier) returns nvarchar(1024)
AS
BEGIN
declare @NAME nvarchar(1024);
select @NAME = CASE WHEN SOLICITCODE.SITEID IS NULL THEN SOLICITCODE.DESCRIPTION ELSE SOLICITCODE.DESCRIPTION + ' - ' + SITE.NAME END
from dbo.SOLICITCODE
LEFT OUTER JOIN DBO.SITE ON SOLICITCODE.SITEID=SITE.ID
where DBO.SOLICITCODE.ID = @ID;
return @NAME;
END