•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,125 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,773 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 1267 | Replies: 0
 |
| |
•
•
Join Date: Nov 2006
Posts: 6
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
problem with trigger I have a table with a primarykey ID and a unique key for ID_EMP and OSID
When I insert I want to populate the OSID column whth the next int value related to id_emp
My trigger works but is returning the error message:
Warning: Null value is eliminated by an aggregate or other SET operation.
CREATETRIGGER os_osid
ON ordemdeservico
FORINSERT
AS
BEGIN
DECLARE @osid int, @id int
SELECT @osid = CASE WHEN MAX(ordemdeservico.osid) IS NULL THEN 1 ELSE MAX(ordemdeservico.osid) + 1 END
FROM inserted
LEFT JOIN ordemdeservico ON ordemdeservico.id_emp = inserted.id_emp
WHERE ordemdeservico.id_emp = inserted.id_emp
SELECT @id = inserted.id
FROM inserted
UPDATE ordemdeservico
SET ordemdeservico.osid = @osid
WHERE ordemdeservico.id = @id
END
When I insert I want to populate the OSID column whth the next int value related to id_emp
My trigger works but is returning the error message:
Warning: Null value is eliminated by an aggregate or other SET operation.
CREATETRIGGER os_osid
ON ordemdeservico
FORINSERT
AS
BEGIN
DECLARE @osid int, @id int
SELECT @osid = CASE WHEN MAX(ordemdeservico.osid) IS NULL THEN 1 ELSE MAX(ordemdeservico.osid) + 1 END
FROM inserted
LEFT JOIN ordemdeservico ON ordemdeservico.id_emp = inserted.id_emp
WHERE ordemdeservico.id_emp = inserted.id_emp
SELECT @id = inserted.id
FROM inserted
UPDATE ordemdeservico
SET ordemdeservico.osid = @osid
WHERE ordemdeservico.id = @id
END
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode
- Router/Warcraft III/CS 1.6 problem (Networking Hardware Configuration)
- Click event >> window appears? (Python)
- nvidia geforce 5600 graphics problem (Monitors, Displays and Video Cards)
- Windows XP keeps restarting since a new video card (Windows NT / 2000 / XP / 2003)
- Random screen saver problem is killing me (OS X)
- Redhat Linux 6.2 - ipop3d problem? (*nix Software)
- Connection Problems (Networking Hardware Configuration)
- Problem with Windows Update and WinXP (Web Browsers)
Other Threads in the MS SQL Forum
- Previous Thread: Howto | mssql seach and replace?
- Next Thread: New line Character in column alias
