tags:

views:

21

answers:

1

I have a table-valued-function working functionally well. I wanted to reuse its result in multiple SELECT statements. How can I do that?

+2  A: 

You couldinsert the results to a temp table or table variable. You could use the same table valued function in multiple statements but could run into issues if the data is changed from another source while the whole process is running, so I would say the temp table or table variable would be safer.

HLGEM