Hi,
Can anyone one suggest an easy way of cascading certain fields from one returned record to the next until the data changes.
i.e.
Select *
from Table
returns
Date Status Record Type
01/02/2014 04 West
02/02/2014 04
03/02/2014 06
04/02/2014 04 East
07/03/2014 07 North
04/04/2014 09
etc
What I want is
Date Status Record Type
01/02/2014 04 West
02/02/2014 04 West
03/02/2014 06 West
04/02/2014 04 East
07/03/2014 07 North
04/04/2014 09 North
The record Type on the end is cascaded down to the blank fields.
I need to write the SQL code in the simplest of terms, because it needs to be used and understandable by novice coders.