April 9, 2003 at 8:25 am
Hi GOod Morning evryone
I have a table with 50000 rows and 5 columns a,b,c,d,e.I have a column(c) which will gives me the values of 3 variables.I wanted to store these values into other table in the same database with 7 cols,means a,b,c1,c2,c3,d,e.i can do this upto this.But the problem is that tha table is not static,it will be dynamically increasing.I processed the first 50k rows and now i got 10k rows.i have to proces them and then i will get some 30 k i have to process them.If I write a stored procedure for this how to descriminate the the rows that are written into the second table an the rows not are written into the second table.If i can descriminate the rows i can process the rows that are not written into the second table.can u help me out in this.
Thanks.....
April 9, 2003 at 9:21 am
If you could add a column to the first table then when you process the data with your stored procedure you could update this column with a mark that already has been transfered to the other table, and use only the rows that doesn't have that mark
April 9, 2003 at 9:24 am
How to do that,can u please help me out...
suppose i select first 5 k rows and written into second table.then how to updatet the status in the against the column in the first table.
April 9, 2003 at 10:03 am
Hi,I got it...
Thank you
April 9, 2003 at 10:19 am
Shout if you need help!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply