Post reply

Update trigger

  • October 2, 2008 at 2:56 am

    #191718

    i need to update a specific field in another table when one field in my table gets updated.

    Table that is getting updated: tbltimesheet

    Fields that could change: comments

    pk field : timesheetid

    Table to update: tblweek

    field: status

    Forign key field:timesheetid

    The goal is to update the status field when comments field gets updated. I wanted to use trigger .I am using SQL SERVER .any help would be appreciated.

  • October 2, 2008 at 3:52 am

    #879854

    You should try not to cross post (post the same question in more than one category). I probably should have updated this one as it is the more appropriate group for this question but already did the other. http://www.sqlservercentral.com/Forums/Topic579524-54-1.aspx

    Thanks.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply