Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kenone
Starting Member
14 Posts |
 Posted - 2006-03-10 : 04:12:56
|
| I have two SQL Server Tables ie members and pensioners accessed through VB.NET application.When a member attains a retirement age has to become inactive in members' table and his/her details moved to pensioners table as inactive pensioner too.He will remain inactive till at later stage when starting to receive monthly pension ,he/she will become an active pensioner.Is there any means of inactivate/activate specific rows/records accordingly using SQL????? please help!!!! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-03-10 : 04:24:01
|
quote:
Originally posted by kenone
Is there any means of inactivate/activate specific rows/records accordingly using SQL????? please help!!!!
i guess you mean like a flag? add another field and use bit type,1 for active and 0 for inactive...HTH--------------------keeping it simple... |
 |
|
|
|
|
|
inactivate/activate records in the table