Agreed.

This was just a sample of the actual code which is a bit more complicated and I do convert it to actual dates.

Thanks

Great.
I also made a small change that lets me select the range.  If @Choice is NULL, it will work as you have it.  @Choice is the number of years...

My mistake.

You're right. I just marked the latest one.  Didn't notice that the answer was right above it.

And yes, I do understand how it works.  Was...

I forgot I was on 2008.  I use both servers.

This gave me what I needed.

Thanks.

I tried that but got the following error:

Msg 102, Level 15, State 1, Line 25

Incorrect syntax near 'ROWS'.

Am I missing something?

I...

I was able to use this in the actual select statement and it worked perfectly.

Thanks.

That doesn't sum anything because the join only passes back one row.

I get this a the answer:

FullName NewType (No column name) (No column name)
Tom Emp 10 20

The amounts...

Both ways do the job.
Thanks.

I got it to work.

All I did was change the where clause alias from:
WHERE bij