One more thing, when I printed the query as Michael suggested, I get the following:

WITH CTE AS
(
    SELECT
      ...

Thanks a lot Drew for your response.

When I used your solution, I get

2019
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Normally, result looks like this:

2019
60.0000
120.0000
120.0000
60.0000
80.0000
120.0000

All I am trying to do is...

• This reply was modified 5 years, 3 months ago by  ciss1.

Thanks for your response, Michael.

I actually tried that and got incorrect syntax near 'Year_'.

If I remove the single quotes, it gives me invalid column name error.

Please this is more like...

Please don't let my thread die a slow death.

If there is some additional information I need to provide, please let me know.

Thanks

Thank you very, very much.

This worked great.

thanks Daniel.

I apologize if my questionis a bit confusing.

What I wanted to do is reset the ReportOrder.

For instance, let's assume that I just populated a table with 10 records for...