call a user defined function from another user-defined function
No you cannot. Read in BOL about UDF determinism. A UDF must be
deterministic ... i.e. it cannot use GetDate because GetDate is not
deterministic (It returns a different value everytime). So I would
assume that the UDF you are calling from within your UDF is
non-deterministic.
V/R Jim Johnston
MCSD, MCDBA
Quote:
> hi, there
> can i call a user-defined function from another user-defined function. when
> i tried to do so, sql server showed error message saying that "function_name
> is not a recoginzed function".
> please help.
