Re: Date Table

Create the table first, then write a simple stored procedure that loops from '1/1/1900' to '1/1/2001', by increasing a local date variable by 1 and inserting that into the table. ... define idate date; let idate = '1/1/1900'; while idate <= '1/1/2001' do insert into <table> values (idate); let idate = idate + 1; end while ... That's just the pseudo-code, but illustrates the logic. Hope it helps, Arun rmcquire@tsi.gte.com wrote: > I am sure this is a very simple question, but I will ask it anyway. I want to > create a table with a series of dates from 1/1/1900 to 1/1/2001. What is the > EASIEST way to go about this? > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own