If John or Ann were to change settings, would the other one be affected?

To Brian...

Because Ann receives (or inherits) her settings (instructions) from John , only Ann is affected when...

Can the following work...

Select * From Company WHERE

CHARINDEX ('ABC',Name) > 0

NOTE: if possible put the clustered index on the 'Name' column

Thanx guys... greatly appreciated your response. I came up with the same solution the day after I sent the post. At least now i know i wasn't far off

Sorry... maybe I did not explain myself properly... I do not need specifically the result of the next run date... but rather on how it is calculated. That is to say,...

Thanks guys for the quick response. I would stick to the joins as this seems to be the more effective solution with perhaps less adverse impact on the database. Thanks...

Jonathan, I have already considered the option of not going to the server for the data. However ever so often, new records are added to the original data source...

Thanks j.o.s. , ironically just after posting the message I found the info on net send. But your response is highly appreciated as I have been looking for a long...