InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:36:34 GMT20http://www.teradata.com/teradataforum/Topic11004-5-1.aspxHi, it does not work. it did not fetch the record, only insert 1 record. the max value may go up to 999999999999999.thanks,Tue, 22 Apr 2008 15:01:00 GMTnguyent02http://www.teradata.com/teradataforum/Topic11004-5-1.aspxHi Dhiraj,did you try it, this will not work :-)If it's less than 73000 values:insert into tabselect day_of_calendar from sys_calendar.calendarwhere day_of_calendar <= 1000DieterTue, 25 Mar 2008 13:46:13 GMTdnoethhttp://www.teradata.com/teradataforum/Topic11004-5-1.aspxHi,Create table as mentioned below and exec the foll. query.CREATE SET TABLE ,NO FALLBACK ,NO BEFORE JOURNAL,NO AFTER JOURNAL,CHECKSUM = DEFAULT(ID_COL INTEGER GENERATED ALWAYS AS IDENTITY(START WITH 1 INCREMENT BY 1 MINVALUE -2147483647 MAXVALUE 1000NO CYCLE))UNIQUE PRIMARY INDEX ( ID_COL );INSERT INTO SELECT 1 FROM DB_NAME.TABLE_NAME_2 Just make sure, above select query fetches the number of records you want. In this case 1000.Mon, 24 Mar 2008 03:07:09 GMTdhirajpalsehttp://www.teradata.com/teradataforum/Topic11004-5-1.aspxhi, i am needing help on how to create a table (No RAW data to insert) , only generate the count from 1 to 1000. the final table will Counter1...1000Thank you very much.Fri, 21 Mar 2008 15:31:24 GMTnguyent02