UFN_SALESDEPOSITTEMPLATE_GETNAME

            create function dbo.UFN_SALESDEPOSITTEMPLATE_GETNAME(
                @ID uniqueidentifier
            ) returns nvarchar(100) 
            as
            begin
                declare @NAME nvarchar(100);
                select @NAME = [NAME] 
                from dbo.[SALESDEPOSITTEMPLATE] 
                where [ID] = @ID;

                return @NAME;
            end