Hi,

Thanks for the reply. Let me elaborate on what I am doing

I have a sp which has code like below

select * from tbl join udf1 etc.,

udf1 calls another udf2 which...

Hi,

I have a udf. I need to call a sp on the same server. I tried using the above code. But I am getting errors in the secnd step

select *...