call an SQL User Defined Function Within another User Defined Function

Question

I have the following UDF which i want to call another udf that split the result on return

-- =============================================
CREATE FUNCTION [dbo].[ufnGetValueForEmployeeTable]
(   
    @EeID       AS int,
    @ProvisionID    AS int,
    @optionName     AS varchar(4000)
)
RETURNS varchar(128)
AS
BEGIN
    SELECT 
    WHERE  
    RETURN **call here this function** GetOptionValueFromOtherOptions(@optionName ,  @value `this is the value from select` )

Is it possible ? if yes how?

Well, maybe an absurd question, but why don't you just call the inner function instead of nesting them, or use a synonym? What does nesting them buy you except a maintenance headaches and even further restricting optimization? — Aaron Bertrand
– Aaron Bertrand, Commented Aug 16, 2013 at 16:39
well cos the other function is already existing and used for separate functionality too .. but i see your point here. I am not familiar with UDFS and honestly never thought about nesting them — lighty
– lighty, Commented Aug 16, 2013 at 16:45

Gordon Linoff · Accepted Answer · 2013-08-16 16:40:32Z

2

I think you want something like:

declare @retval varchar(128);

select . . .;

select @retval = GetOptionValueFromOtherOptions(@optionName ,  @value);

return @retval;

answered Aug 16, 2013 at 16:40

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aaron Bertrand · Accepted Answer · 2013-08-16 16:46:54Z

0

Try:

RETURN (SELECT dbo.GetOptionValueFromOtherOptions(@optionName, @value));

However I suggest this with extreme caution: UDFs are bad enough on their own; nesting them will only compound the issue. Probably better to make the code that requires one function vs. the other to call them directly instead of using this nesting approach.

answered Aug 16, 2013 at 16:46

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

Collectives™ on Stack Overflow

call an SQL User Defined Function Within another User Defined Function

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related