Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: automatic updates

    I have two sql 2000 server tables one is active and one is terminated (I inherited this db) and I was thinking of having the active table automatically update the terminated table when an employee is terminated. Access is at the front end and in the form of the active table theres a drop down text box that has the employement status(active, terminated, on leave...etc) so when the status turns into terminated i want the acitve table to send those records to the terminated table, ( the data in both tables are not exactly the same). looking into a trigger or stored procedure. This is the first time I've done this so I'm doing some reasearch on how to handle it. Any suggestions

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by desireemm
    Any suggestions

    Yeah,

    use a trigger or a stored procedure
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    thank you

    Ok good thank you Brett (reassurance I'm going about it the right way) was thinking a Trigger would be good to update the termination table as soon as the status in the active table is changed to "TERMINATED" it will automatically send the data to that table. Can I show you my code to make sure I'm doing this correctly??

    Thanks guys

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by desireemm
    Can I show you my code to make sure I'm doing this correctly??
    Is that anything like "I'll show you mine if..."

    NEVERMIND!!!

    -PatP

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Wink LoL

    You know a dirty mind is a terrible thing to waste

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by desireemm
    You know a dirty mind is a terrible thing to waste
    I'd always heard that a waist was a terrible thing to mind.

    -PatP

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by desireemm
    You know a dirty mind is a terrible thing to waste

    Boy I can see where this is hedading

    So Yes you can show me yours....can you send attachments in emails?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    And you should check out our little party we got going on

    http://www.dbforums.com/showthread.p...29#post3693529

    The more the merrier...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by Pat Phelan
    I'd always heard that a waist was a terrible thing to mind.

    -PatP

    Luckily it's just a head shot

    http://searchdatabase.techtarget.com...379843,00.html
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  10. #10
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Somebody should submit that to http://www.amihotornot.com/
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  11. #11
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    You should really quit your day job and do stand up....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  12. #12
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    Somebody should submit that to http://www.amihotornot.com/
    Bleah! It was something like 03:00, about the third day of Tech-Ed. They wanted a picture of me in one of their logo'ed shirts. I never should have agreed!

    -PatP

  13. #13
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I used to work with an IT guy who had done stand-up comedy. He was very funny, very similiar to Stephen Colbert on Comedy Central's Daily Show. The problem was that every time you asked him for assistance you had to sit through a minute or two of hillarious but biting sarcasm before he'd solve your problem.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  14. #14
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What did he solve? Excel?

    And where did my desiree go?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  15. #15
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by blindman
    I used to work with an IT guy who had done stand-up comedy. He was very funny, very similiar to Stephen Colbert on Comedy Central's Daily Show. The problem was that every time you asked him for assistance you had to sit through a minute or two of hillarious but biting sarcasm before he'd solve your problem.
    I don't remember that!

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •