Update records in table from CTE

by

Updates you make to the CTE will be cascaded to the source table.

I have had to guess at your schema slightly, but something like this should work.

;WITH T AS
(   SELECT  InvoiceNumber, 
            DocTotal, 
            SUM(Sale + VAT) OVER(PARTITION BY InvoiceNumber) AS NewDocTotal
    FROM    PEDI_InvoiceDetail
)
UPDATE  T
SET     DocTotal = NewDocTotal

More Related Contents:

  1. Difference between CTE and SubQuery?
  2. Common Table Expression, why semicolon?
  3. When to use Common Table Expression (CTE)
  4. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  5. CTE error: “Types don’t match between the anchor and the recursive part”
  6. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  7. How do I UPDATE from a SELECT in SQL Server?
  8. How to return only the Date from a SQL Server DateTime datatype
  9. How to calculate age (in years) based on Date of Birth and getDate()
  10. CROSS JOIN vs INNER JOIN in SQL
  11. Referring to a Column Alias in a WHERE Clause
  12. Function vs. Stored Procedure in SQL Server
  13. Limit on the WHERE col IN (…) condition
  14. converting Epoch timestamp to sql server(human readable format)
  15. Getting result of dynamic SQL into a variable for sql-server
  16. How to get difference between two rows for a column field?
  17. How to update Identity Column in SQL Server?
  18. Concatenate values based on ID
  19. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  20. Scope of temporary tables in SQL Server
  21. SQL Select Upcoming Birthdays
  22. SQL Server 2005 ROW_NUMBER() without ORDER BY
  23. Can an INNER JOIN offer better performance than EXISTS
  24. Find the real column name of an alias used in a view?
  25. How to get the identity of an inserted row?
  26. How to create a pivot query in sql server without aggregate function
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. SQL Server FOR XML Path make repeating nodes
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment