UFN_TRANSLATIONFUNCTION_GETACCOUNTCODENAME

Return

Return Type
nvarchar(100)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_TRANSLATIONFUNCTION_GETACCOUNTCODENAME(@ID uniqueidentifier) returns nvarchar(100
as
begin
    declare @s nvarchar(100);
    select @s = SHORTDESCRIPTION from dbo.PDACCOUNTSEGMENTVALUE where ID = @ID;
    return @s;
end