hi, im not that good in sql and i dont know how to make a stored procedure. in my windows form, i need to archive two table from my database but only those inactive user will be archived. if user is not updating his profile for a month.... e.g

TABLE1
username(PK) | pasword| date |
kapojian | 12345 | aug,4 2011


TABLE2
username(FK)| activity | meals |
kapojian | basketball | rice |

can someone show a sample code? or is there better way to archive records rather than stored procedure??? thanks..

>can someone show a sample code? .

Show us your code work please?

>is there better way to archive records rather than stored procedure???

Nope!

>I dont know how to make a stored procedure.

Buy a good book and learn something useful.