Use a conditional split and only add an output for the rows you actually want to process.

Drew

Try the following

, COALESCE(gl.YEAR1, MAX(gl.YEAR1) OVER(PARTITION BY Accts.ACTINDX ORDER BY Period.PeriodNo ROWS UNBOUNDED PRECEDING) as [Year]

Because you have a GROUP BY, you may need...

Here is my solution using a modified version of Lowell's sample data.  (I treated numbers as numbers rather than strings.)

/*  SET UP THE SAMPLE DATA...

I'm no longer getting unread posts in a bold font.  I also used to be able to hover over a link and get an arrow that would take me to...

Reported as spam.

ParallelPeriod might be more appropriate.

Reported as spam.

You really should be using a reporting tool (like SSRS) to do complicated reporting like this.  Most reporting tools can easily handle complex reports such as this.

If you...