Code:
CREATE TRIGGER [izmena kljuceva] ON [dbo].[temp1]
FOR INSERT
AS
DECLARE @settlementID CHAR(6), @jkdID CHAR(6), @naceID CHAR(5), @ownershipID TINYINT, @formID INT, @agencyID CHAR(2), @registrantID UNIQUEIDENTIFIER
SELECT @registrantID = registrantID, @settlementID = settlementID, @jkdID = jkdID, @naceID = naceID, @ownershipID = ownershipID, @formID = formID, @agencyID = agencyID FROM INSERTED
-- PROVERA VREDNOSTI
IF NOT EXISTS (SELECT settlementID FROM settlementCounty WHERE settlementID = @settlementID)
BEGIN
SET @settlementID = NULL
END
IF NOT EXISTS (SELECT jkdID FROM jkd WHERE jkdID = @jkdID)
BEGIN
SET @jkdID = NULL
END
IF NOT EXISTS (SELECT naceID FROM nace WHERE naceID = @naceID)
BEGIN
SET @naceID = NULL
END
IF NOT EXISTS (SELECT ownershipID FROM ownership WHERE ownershipID = @ownershipID)
BEGIN
SET @ownershipID = NULL
END
IF NOT EXISTS (SELECT formID FROM companyForm WHERE formID = @formID)
BEGIN
SET @formID = NULL
END
IF NOT EXISTS (SELECT agencyID FROM regAgency WHERE agencyID = @agencyID)
BEGIN
SET @agencyID = NULL
END
UPDATE temp1
SET settlementID = @settlementID, jkdID = @jkdID, naceID = @naceID, ownershipID = @ownershipID, formID = @formID, agencyID = @agencyID
WHERE registrantID = @registrantID
DELETE FROM registrants WHERE registrantID = @registrantID
CREATE TRIGGER [izmena kljuceva] ON [dbo].[temp1]
FOR INSERT
AS
DECLARE @settlementID CHAR(6), @jkdID CHAR(6), @naceID CHAR(5), @ownershipID TINYINT, @formID INT, @agencyID CHAR(2), @registrantID UNIQUEIDENTIFIER
SELECT @registrantID = registrantID, @settlementID = settlementID, @jkdID = jkdID, @naceID = naceID, @ownershipID = ownershipID, @formID = formID, @agencyID = agencyID FROM INSERTED
-- PROVERA VREDNOSTI
IF NOT EXISTS (SELECT settlementID FROM settlementCounty WHERE settlementID = @settlementID)
BEGIN
SET @settlementID = NULL
END
IF NOT EXISTS (SELECT jkdID FROM jkd WHERE jkdID = @jkdID)
BEGIN
SET @jkdID = NULL
END
IF NOT EXISTS (SELECT naceID FROM nace WHERE naceID = @naceID)
BEGIN
SET @naceID = NULL
END
IF NOT EXISTS (SELECT ownershipID FROM ownership WHERE ownershipID = @ownershipID)
BEGIN
SET @ownershipID = NULL
END
IF NOT EXISTS (SELECT formID FROM companyForm WHERE formID = @formID)
BEGIN
SET @formID = NULL
END
IF NOT EXISTS (SELECT agencyID FROM regAgency WHERE agencyID = @agencyID)
BEGIN
SET @agencyID = NULL
END
UPDATE temp1
SET settlementID = @settlementID, jkdID = @jkdID, naceID = @naceID, ownershipID = @ownershipID, formID = @formID, agencyID = @agencyID
WHERE registrantID = @registrantID
DELETE FROM registrants WHERE registrantID = @registrantID
I sad hoću da uradim sledeće:
Code:
INSERT INTO temp1
SELECT * FROM registrants
INSERT INTO temp1
SELECT * FROM registrants
Ali jednostavno ne radi! Kolega kaže da treba da mu zadam da uzima jedan po jedan zapis, pa će raditi. Jel ima neko ideju o čemu se radi?
Upućen sam na onaj FETCH NEXT RECORD... ali i dalje ne kapiram
p.s. It's kind of a EMERGENCY !!!
[Ovu poruku je menjao VerbatimBOT dana 27.09.2006. u 14:52 GMT+1]
Winners never quit, quitters never win.