Home Forums SQL Server 2008 SQL Server Newbies Trigger to set a value for a column RE: Trigger to set a value for a column

  • June 17, 2013 at 2:38 pm

    #1624795

    details or ddl wasn't available, so here's my best guess.

    is the trigger setting values on the table is is set for, or a completely different table ("Audit")?

    because you obfuscated everything, you also lost any details for the actual commands;

    from your description now, a column"X" gets set to a table, instead of a column in a table?

    if there is value in A.description the value for X will be B

    regardless of the details, you'll just need to do an UPDATE FROM statement in your trigger

    a rough draft looks something like this i guess:

    UPDATE myTarget

    SET MyTarget.X = B.SomeColumnName

    from Audit myTarget

    inner join INSERTED ON myTarget.ID = INSERTED.ID

    left join B on myTarget.Id = B.ID

    left join C on B.Id = C.ID

    left join D on C.ID = D.ID

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!