Home Forums SQL Server 7,2000 T-SQL Trigger to insert from one (new row) in table to another table RE: Trigger to insert from one (new row) in table to another table

  • October 1, 2013 at 6:01 am

    #1654848

    ngustafson-1056093 (10/1/2013)

    The stored procedure is a standard proc used for different circumstances. I prefer to have a trigger execute the insert

    Can you post the code for the sproc?

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden