using a parameterized SQL query within another SQL query
Will Holtz
2015-12-10 13:50
Status: Closed
I'm building a parameterized SQL query that is complex enough that I'd like to break it up into some smaller queries that I can string together. Is it possible to call a parameterized SQL query from another SQL query? I searched the docs a bit, but couldn't find anything directly related.
thanks,
-Will
jeckels responded:
2015-12-12 18:09
Hi Will,
Yes, this will work. You'll be prompted for the parameter value when you try to execute either the outer or inner query. You don't have to define the parameter in the outer query.