Steve Jebson
asked on
Select all children of parent where >1 child.DateCompleted not null
Hi,
I have an existing select query in reporting services that returns Jobs that have Joblines. The Jobline may have a DateCompleted set. What i'd like to do is return all Joblines within the Job if one or more DateCompleted's are set, if that makes sense ?
Sorry for the description, it's all part of being a novice ;-)
thanks
I have an existing select query in reporting services that returns Jobs that have Joblines. The Jobline may have a DateCompleted set. What i'd like to do is return all Joblines within the Job if one or more DateCompleted's are set, if that makes sense ?
Sorry for the description, it's all part of being a novice ;-)
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks.
I know what you mean. I've asked 50-times more questions than I've answered.
I know what you mean. I've asked 50-times more questions than I've answered.
ASKER
Seems obvious now you've spelt it out for me ;-)