Help with SQL trigger
- or -
Post a project like this2452
£20(approx. $25)
- Posted:
- Proposals: 8
- Remote
- #1655922
- Awarded
Senior Developer / Solution Architect / Database Expert / System Integration specialist
Colombo
5129291189697150157715939111742586176446817716411777324
Description
Experience Level: Entry
General information for the business: Various
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: I need someone to rewrite the attached trigger so it supports multiple rows being in the inserted table.
At the moment it works fine when a single row is updated. But fails if multiple rows are being updated
"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, = or when the subquery is used as an expression."
Extra notes:
Database management system (DBMS): Microsoft SQL Server
Description of requirements/functionality: I need someone to rewrite the attached trigger so it supports multiple rows being in the inserted table.
At the moment it works fine when a single row is updated. But fails if multiple rows are being updated
"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, = or when the subquery is used as an expression."
Extra notes:
Ben D.
100% (27)Projects Completed
23
Freelancers worked with
24
Projects awarded
53%
Last project
7 Oct 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies