I have a Function to returns a table. I can execute a function like following:
I Want to Know if i can call a function in other select. For example:
I need to do this but I can't.
Someone can help me?
If you were on 2005+ you could use cross apply
answered Nov 10 '09 at 10:47 AM
Matt Whitfield ♦♦
You can't return a table in the SELECT clause, but you can include the function in the FROM clause. (SQL 2005 syntax)
You can only use a scalar valued function in the select clause or a subselect that will return only one row and one column.
the statement below will work if the function only returns one row:
answered Nov 10 '09 at 10:57 AM
You can call a function in the
answered Nov 10 '09 at 10:23 AM
Kev Riley ♦♦