December 15, 2008 at 12:16 am
Good Afternoon Everybody!!!!
One of my site have a more than 41,000,00 data. Problem is i want to this data into 41 tables, per table i have a keep 1,000,00 data.
I'm creating one excel file given a name is Table_distribution contains three coulmn 1)Table_Name 2)Start 3)End
ex: Table_Name Start End
new_ads_1 1 100000
--------_2 100001 200000
continue this format to 41 table. this file i import my database.
this 41,0000 data store in ads table
for my logic:----
For each rows in table_distribution
if exist table with tablename
drop that table
create new table insert into with tablename
having structure of ads
set identity seeds as start
insert data from ads into new table
for ad_id <= ens
next row
In ads table field name are
( ad_id, ad_category,title,brief,large,image_url,seller_id,dated,source_id,source,details_from_source,city_id,source_date,source_id_bak,publish,deleted)
So, how i will write this Stored Procedure in sql 2000 ???????
December 15, 2008 at 12:24 am
ganesha2181 (12/15/2008)
One of my site have a more than 41,000,00 data. Problem is i want to this data into 41 tables, per table i have a keep 1,000,00 data.
Why?
So, how i will write this Stored Procedure in sql 2000 ???????
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
Also in the future, please don't post new threads for questions you've already asked - http://www.sqlservercentral.com/Forums/FindPost616686.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply