How to pass parameters to a SQL view

Have you every wanted to pass a parameter to a view? It’s a standard request that can be a bit difficult to implement.

…

Unfortunately, there are more than a few tools still out there that aren’t prepared to accept a result set from a stored procedure or function.

In these cases you can inject your parameter into the database somewhere where the view can read it.

Read the rest on the Optimal BI blog.

Comments