I have just patched to SP4 and now get the same results as fcallawa.

Val always comes back as the constant 1 even if there is a missing row in the...

Scott, you are quite right. I had it in my head that it was the self join that was throwing the spanner in the works. I did try it on...

I am sure there are explanations for its mis-behaviour, but to me its more than 'slightly unexpected'. Yes, I am sure that under the lid there may be indicators that things...

Exactly

ttfn

When does 'interesting behaviour' get to be a bug?

When ISNULL(Val, 0) returns 1 when val returns NULL, that is a bug.

Thanks for the input guys. If I had the energy I...

Hi Rajesh - Yes, you are right. The first thing I did was to try it on a pair of tables instead of the table and the view and it...

Hi Jon

COALESCE(Val,0) returns the expected value of 0 for the missing rows in vw. Thats something Ive learnt today - I didnt know about COALESCE. Thanks.

CASE WHEN Val IS NULL...

Thanks very much for that.

We had better try it before we hit a crisis situation!

Thanks for that.

Does this ensure that there will be no changes committed to any of the databases during the execution of the job?

Say I have a transaction that makes changes...