UFN_TRANSLATIONFUNCTION_PDACCOUNTSEGMENTMAPPINGLONGDESCRIPTION

create function dbo.UFN_TRANSLATIONFUNCTION_PDACCOUNTSEGMENTMAPPINGLONGDESCRIPTION(@ID uniqueidentifier) returns nvarchar(50) 
as
begin
    declare @s nvarchar(50);

    select @s = LONGDESCRIPTION
    from dbo.PDACCOUNTSEGMENTMAPPING
    where ISDEFAULT = 1 and LONGDESCRIPTIONID = @ID


    if @s is null 
        select @s= LONGDESCRIPTION 
        from dbo.PDACCOUNTSEGMENTMAPPINGVIEW
        where LONGDESCRIPTIONID = @ID 


    return @s;
end