Thank's a lot, Dave.

It works, and the solution also works on my production DB (which involves a lot more fields).

So - thanks again !

Regards,

Dagfinn

Thanks for your reply, Dave!

That gives me the following result - correct number of rows, but not the correct content...

CustNoContractNoRNoDateFromDiscount

2322010-01-01 00:00:00.000NULL

1132010-01-01 00:00:00.000NULL

1122010-01-01 00:00:00.000NULL

1112010-01-01 00:00:00.000NULL

1112008-01-01 00:00:00.00050

1122009-01-01 00:00:00.00050

I think I must try...

That works perfectly on my SQL2008 :-), but I forgot to mention that the server in question is a SQL Server 2000.

Sorry about that...

The code posted contains a lot of errors. Misspelled procedure names, missing columns, wrong aliases.

I don't have time to do the error checking right now, but will post my findings/corrections...