Home Forums SQL Server 2008 SQL Server 2008 - General Trigger to update existing records RE: Trigger to update existing records

  • December 20, 2012 at 5:51 am

    #1570504

    Minnu (12/20/2012)

    Am having a table called products with 4 columns, whenever any new insert or update happens,

    column "Product_Name_Expiry" will be udpated with prouduct_Name : Product_expriry_date.

    IDProduct_NameProduct_Expiry_Date Product_Name_Expiry

    -------------------------------------- ---------------------------------

    1001Veh2012-08-20 00:00:00.000 Veh: 2012-08-20 00:00:00.000

    1075STL2012-08-20 00:00:00.000 STL: 2012-08-20 00:00:00.000

    1081TKL2012-08-20 00:00:00.000 TKL: 2012-08-20 00:00:00.000

    1569JKT2012-08-20 00:00:00.000 JKT: 2012-08-20 00:00:00.000

    1012Veh2012-08-20 00:00:00.000 NULL

    1013STL2012-08-20 00:00:00.000 NULL

    1014TKL2012-08-20 00:00:00.000 NULL

    1515JKT2012-08-20 00:00:00.000 NULL

    ID : 1001, 1075, 1081,1569 are the new inserted / updated records, hence trigger fired and product_name_expriry,

    My requirement i want to udpate proudct_name_expiry is without updating existing records "1012,1013,1014,1015"

    i want a one time stored procedure to udpate existing records.

    so, are you going to post the CREATE TRIGGER code and the CREATE TABLE definition?

    If you want to perform the same update as the trigger, we need the code of the trigger.

    you undoubtedly would have had a working answer yesterday if you had the chance to post the code.

    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!