Loop in s SQL Query

Hello,

I converted an old VB6 application to NET. There are several treatments that
I would turn it into stored procedures. One treatment is not particularly
easy to transform. Here is my problem. I have a table that contains the
information of customers. We can identify a customer with a unique key. The
user of the application must select a year in a drop down list eg 2002. The
application has a starting year. The starting year is 1999 and it never
changes because it is a constant. A calculation is made between the two
years. This calculation is to obtain a period. The calculation is as
follows:

2002 + 2 - 1999 = 5

With this value, in VB6, it is providing me am array of 0 to 5 elements.
So, I have to reproduce the same thing but in a table. I must have this:

Custid Year
1 1999 (0)
1 2000 (1)
1 2001 (2)
1 2002 (3)
1 2003 (4)
1 2004 (5)
2 1999 (0)
2 2000 (1)
2 2001 (2)
2 2002 (3)
2 2003 (4)
2 2004 (5)
3 1999 (0)
3 2000 (1)
3 2001 (2)
3 2002 (3)
3 2003 (4)
3 2004 (5)
....

Here is my question. As my knowledge of SQL its limited, is it possible to
do this with an SQL query that acts like a kind of loop?

Thank you!

Marc R.

>> As my knowledge of SQL its limited, is it possible to do this with an SQL query that acts like a kind of loop? <<

No, SQL is declarative and does not like the concept of a loop. We
work with SETS and do them ALL AT ONCE -- no sequential processing. If
you think this weird, loop at LISP and recursion instead of loops.

What we often do is create a table of integers from 1 to (n) and then
JOIN to it for many of things that a procedural language would do in
a loop. We also turn IF-THEN-ELSE logic into CASE expression.

Get a copy of THINKING IN SETS for some help with the mindset
changes. Could be worse; could be LISP