|
Posted by sql_server_user on 05/10/06 21:55
Thanks Erland.
The query as you've rewritten it is right on, as long as we have the
object id specified in the outer part of the query so that the history
row is fully specified when given the time period from the subquery. I
guess what I was concerned about was correlated subqueries where this
isn't the case, but I can't think of any actual examples for this
application, so maybe I don't have to worry about it.
I will definitely try the other permutations of the query you
suggested.
Seth
Navigation:
[Reply to this message]
|