Archives of the TeradataForum

Message Posted: Thu, 03 Nov 2005 @ 21:33:54 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hope this helps.

     INSERT INTO STUDENT
     Select
        Day_Of_Calendar
       ,'FirstName'
       ,'LastName'
       ,'Major'
       ,55000
       ,'31-May-06'
     >From  sys_calendar.Calendar
     Where Day_Of_Calendar <= 100
     ;

Good Luck.

	<Prev	Next>		<<First	<Prev	Next>	Last>>