[ VerbatimBOT @ 27.09.2006. 13:32 ] @
Imam sledeći trigger: 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 I sad hoću da uradim sledeće: Code: 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] |