ROW NUMBER LINKING based on date

SQLServerCentral » Latest topics

ROW NUMBER LINKING based on date

Hi,

Thanks in advance for anyone who helps but I thought I was quite a SQL expert but this issue has baffled me for a few days now and I can't seem to work out the best way to achieve a result.
I have two tables:-

more info...