Get returned values from table-valued function using SQLdatasource

Question

I made a simple Table-valued function that returns an Integer and a string. I've looked around but couldn't find anything about retrieving the returned data with a SQLdatasource.

I've tried using it the same way I used it for a scalar-valued function but then I keep getting the error:

The request for procedure 'x' failed because 'x' is a table valued function object.

Is it even possible to call a table-valued function using a SQLdatasource?

What do you mean "using it the same way I used it for a scalar-valued function" - have you used a scalar-valied function in the SQLDatasource? — Comfortably Numb
– Comfortably Numb, Commented Sep 30, 2013 at 13:40

Comfortably Numb · Accepted Answer · 2013-09-30 13:48:26Z

2

If you want to use table-valued function this way, you need to make it a part of a query. E.g.

SELECT * FROM MyTableValuedFunc()

and use that query in your SQLdatasource

answered Sep 30, 2013 at 13:48

Comfortably Numb

39.9k17 gold badges82 silver badges147 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get returned values from table-valued function using SQLdatasource

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related