Hi Chris

Sorry for this inordinate delay. I couldn't upload the attachments on Friday and I didn't have access to this data at home, so didn't make the post then.

Here it...

Hi Chris

Thanks for that!I fully understand what you are trying to do with the CTE's. I have run the query with the CTE's.

The problem, however, remains the same, that is,...

Hi ChrisM@Work

Thanks a zillion for your response. That works fine. No problems.

A couple of questions though :-

First, whilst both 'Over Partiion By...' and the derived table sub-query do the same...

Hi Gail

Thanks for your response.

I don't know how would the table definition help but here they are :-

evd_NonNBV_ForChecking_BAU

([METER_ID] [varchar](10) NOT NULL,

[BILLING_START_DATE] [smalldatetime] NOT NULL,

[BILLING_END_DATE] [smalldatetime] NOT NULL,

[RECORD_ID] [int] IDENTITY(1,1) NOT...

Hi Koen

Thanks for the link - I did see that page and I tried to exactly what it said (it appear to be a simple thing to do even to...

Hi SSCommitted

Thanks for letting me know about the CTE - just read a bit about it!

Even so, doesn't table 'b' need to be said (defined) somewhere in the CTE as...

Hi Guys

Thanks for your responses.

David

Where is the table definition for your table 'b'? And how do you know that the rows in table 'b' will be ordered in the same...