How to move records to another table in SqlServer 2005.

Question

0.00/5 (No votes)

See more:

Hello EXPERTS !!

am working on Asp.Net, C#, SqlServer 2005.

I have a Registration page for Registering a web application....its working fine and storing in database table.

I have 2 Tables in SqlServer 2005 Database.
1)UserInfo
2)UserInfo_Archived

When UserInfo Table reaches 200 records....from this 200 records, 50 Records should be moved to UserInfo_Archived Table.

This process should be continued.

for this am using gridview to display the data.

Please help, how to move records from one table to another table if the table reaches 200 Records.

Thanks in Advance.

Posted 15-Feb-13 20:04pm

Software Engineer 892

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bandi Ramesh · Answer 1 · 2013-02-15T20:16:00

Solution 1

1. Check the COUNT of the rows in UserInfo table when you are inserting records
2. If COUNT<200 then no problem.
3. IF COUNT=200, write a query or stored procedure to dump the data from UserInfo to UserInfo_Archieved. Delete the rows which are dumped to UserInfo_Archieved.

Posted 15-Feb-13 20:16pm

Bandi Ramesh

Sarabjot Singh Makkar · Answer 2 · 2013-02-15T23:54:00

Solution 2

Please refer:

SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE[^]

Posted 15-Feb-13 23:54pm

Sarabjot Singh Makkar

Updated 16-Feb-13 1:24am

v2