Member Avatar for kapojian

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..

  • 2 Contributors
  • 1 Reply
  • 103 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

>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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.