| Subject | semantics of join with selectable stored procedure |
|---|---|
| Author | woodsmailbox |
| Post date | 2009-04-14T13:59:32Z |
Hi,
What are the semantics of joining with a selectable stored procedure? Are they defined somewhere so I can read it?
Lemme split this in two questions:
1) I want to know if there's any guarantee that the procedure is executed only once when its parameters are not correlated with any fields from joined tables.
2) What is the semantics for joining with correlated parameters? It seems to be working only with left join.
Thanx,
Cosmin.
What are the semantics of joining with a selectable stored procedure? Are they defined somewhere so I can read it?
Lemme split this in two questions:
1) I want to know if there's any guarantee that the procedure is executed only once when its parameters are not correlated with any fields from joined tables.
2) What is the semantics for joining with correlated parameters? It seems to be working only with left join.
Thanx,
Cosmin.