Trigger with multiple rows

Hot Topic

Unable to Uninstall SQL server 2005 Express
BUG REPORT: ReadWriteVariables different between Script Task and Script Component
Can't instantiate a ISQLDMOApplication object from a 64-bit C++ executable
Does any one know how to reset sa Account?
Stepping over the line
Need to setup correctly
Error in SQL Server Management Studio Express when Attach DB
How can we deal with unknown member in cubes for data mining?
how to make the contents of sqlserver tables, case sensitive?
BSM - Alerts

SQL Server

The SQL Network Interface library was unable to register SPN. Error: 0x490
Basic Mirroring Setup Help
Reg Database design
SSIS ODBC Source Component
Foreach loop for DBASE IV problem
Dynamic Page Breaks
Two issues with SSIS script
SQL Management Studio integration with SourceSafe
Avoid splitting trees by value missing
Database Mirroring: Cannot set the Mirror Server instance as the partner on Principle server

Trigger with multiple rows

Hi i've searched a lot with no results, im trying to do a trigger, this is the scenario

Got 3 tables, Product, Lines, Sublines

If Update Multiple sublines it should be updated to the products table, but i cant because the inserted table has multiple rows, the only way to do this is using cursors

(Note, i cant do this using cascade because there are others, if i include this get a circular problem so i have to solve this other way)




Answer this question

Trigger with multiple rows

  • Wint

    You have to provide more info, perhaps you can post some DDL of the table and a scenario where you show what you are trying to do.

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Trigger with multiple rows
Answer this question