Does anyone know of a sneaky/devious way to pass a parameter (value) from a view to the input parameter of a multi-statement table valued function? I am trying to substitute a function for a table referenced in the view to return a single row.
I am limited to using a view by third party software and can't do any pre-processing. I simply have a pop up window that accepts an input parameter of search argument(s) that matches existing column value(s) for a column that exists in the view.
Most replies to this question are "you can't get there from here". Anybody have another route I can follow. Maybe a way to convince the view to be a little less static?