Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

passing parm from view to multistatement table valued function Expand / Collapse
Posted Thursday, April 18, 2013 3:54 PM


Group: General Forum Members
Last Login: Friday, December 2, 2016 11:35 AM
Points: 1,502, Visits: 172
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?
Post #1444182
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse