Friends,
I have a Function to returns a table. I can execute a function like following:
SELECT *
FROM dbo.FN_Function(1)
I Want to Know if i can call a function in other select. For example:
SELECT ID_Table,
dbo.FN_Function(ID_Table)
FROM [Table]
I need to do this but I can't.
Someone can help me?
If you were on 2005+ you could use cross apply
Select id_table, fn.* from table cross apply dbo.fn_function(id_table)
You can't return a table in the SELECT clause, but you can include the function in the FROM clause. (SQL 2005 syntax)
SELECT * FROM myTable t
CROSS APPLY dbo.FN_Function(t.ID_Table)
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:
SELECT *, (SELECT MyCol FROM DBO.FN_Function(t.ID_Table)) AS myFnCol FROM myTable t
You can call a function in the SELECT if it is a scalar valued function, not a table-valued function. In other words if the function returns a single value, you can. if it returns a table, then treat it as a table.
