I have a question. You cannot use Temp tables in a UDF. What are the implications of this??
I wanted to created a UDF which needed to return a table based of several tables created on the fly. I made them temp tables as each connection has different data created on the fly - and obviously I don't want different connections accessing each others data.
I am assuming a UDF does not ensure this. Am I right?
Thanks
Elmo
I wanted to created a UDF which needed to return a table based of several tables created on the fly. I made them temp tables as each connection has different data created on the fly - and obviously I don't want different connections accessing each others data.
I am assuming a UDF does not ensure this. Am I right?
Thanks
Elmo