Add a sql server table-valued function in schema

Data Abstract
1

Hi,

is there a way to add to the schema a function that has two parameters and returns a dataset based on these parameters?

If not is there another way to have that kind of functionality?

Thanks in advance

Yiannis

2

Hi,

You can create a stored procedure that will accept two parameters and return required dataset. this stored procedure can be registered as a table in Schema.