Skip to Content
Mar 30, 2019 at 01:01 PM

Stored procedure instead of Table Function



I have some complex join conditions and hence wanted to use a Table Function ( As scripted view is no longer recommended). However, it looks as if the table function has its own limitation in terms of handling the multiple input values. I saw a post where there was a workaround mentioned but guess even that would accept only limited values.

Hence, i thought of creating a stored procedure but am not sure how to call it in a graphical view. All the examples that i have seen is to consume the procedures in a scripted view. If the scripted view is obsolete then does that mean the procedure call is also obsolete or is there a way to consume procedures in graphical view ? Please suggest.