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...

CustNo ContractNo RNo DateFrom Discount

2 3 2 2010-01-01 00:00:00.000 NULL

1 1 3 2010-01-01 00:00:00.000 NULL

1 1 2 2010-01-01 00:00:00.000 NULL

1 1 1 2010-01-01 00:00:00.000 NULL

1 1 1 2008-01-01 00:00:00.000 50

1 1 2 2009-01-01 00:00:00.000 50

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...