THANK YOU A LOT !!!!!

I did not use Pivot .....

befor end while: set @year_from =@year_from +1

now i have thia table:

year amount

2004 4

2005 ...

Thank you for your answer.

I need to create report. User choose between wich years he want to see the report.

for example beetween 2004 and 2009.

My steps :

CREATE TABLE TempTable([year] int...