Sql updating multiple rows
The code you posted doesn't have a sub-query, and an UPDATE statement cannot be a subquery.-- Rod at work Check out these links on how to get faster and more accurate answers: Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? You Need a Question How to Post Performance Problems Crosstabs and Pivots or How to turn rows into columns Part 1Crosstabs and Pivots or How to turn rows into columns Part 2 I know that code doesn't have a subquery, I stated that I also tried a subquery using where exists.If you think its expensive to hire a professional to do the job, wait until you hire an amateur.Introduction to SQL SQL Lesson 1: SELECT queries 101 SQL Lesson 2: Queries with constraints (Pt. 2) SQL Lesson 4: Filtering and sorting Query results SQL Review: Simple SELECT Queries SQL Lesson 6: Multi-table queries with JOINs SQL Lesson 7: OUTER JOINs SQL Lesson 8: A short note on NULLs SQL Lesson 9: Queries with expressions SQL Lesson 10: Queries with aggregates (Pt. 2) SQL Lesson 12: Order of execution of a Query SQL Lesson 13: Inserting rows SQL Lesson 14: Updating rows SQL Lesson 15: Deleting rows SQL Lesson 16: Creating tables SQL Lesson 17: Altering tables SQL Lesson 18: Dropping tables SQL Lesson X: To infinity and beyond! Target Table AS tgt INNER JOIN ( VALUES (1, 'a', 'k', 'x', ...), (2, 'b', 'l', 'y', ...), (3, 'c', 'm', 'z', ...) ) AS src (ID, Column1, Column2, Column3, ...) ON tgt. When you write the code for a DML trigger, consider that the statement that causes the trigger to fire can be a single statement that affects multiple rows of data, instead of a single row.Purchase Order Header SET Sub Total = Sub Total (SELECT SUM(Line Total) FROM inserted WHERE Purchase Order Header. USE Adventure Works2012; GO CREATE TRIGGER New PODetail3 ON Purchasing.
What I really want to know is if it is even possible to run one update query to update multiple distinct rows or if I need to do a loop.
However, because an INSERT trigger can be fired by an INSERT INTO () SELECT statement, the insertion of many rows may cause a single trigger invocation.
Multirow considerations are especially important when the function of a DML trigger is to automatically recalculate summary values from one table and store the results in another for ongoing tallies.
Purchase Order Header SET Sub Total = Sub Total Line Total FROM inserted WHERE Purchase Order Header. Purchase Order ID END ELSE BEGIN UPDATE Purchasing.
Purchase Order Header SET Sub Total = Sub Total (SELECT SUM(Line Total) FROM inserted WHERE Purchase Order Header.
This can also be used to change the column to NULL if the column has no default and is defined to allow null values.