[es] - SELECT * (kako odvajati posle jedan po jedan zapis)

VerbatimBOT
Aleksandar Dragosavac
Senior .NET Developer
Serbia, Belgrade

Član broj: 84129
Poruke: 224
217.24.18.*

Sajt: https://www.xing.com/prof..

Profil

SELECT * (kako odvajati posle jedan po jedan zapis)

^{27.09.2006. u 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]}

Winners never quit, quitters never win.

^{27.09.2006. u 13:32}

Fedya
Fedor Hajdu
Senior Software Engeneer, Ammado Internet Services
Novi Sad

Član broj: 28246
Poruke: 583
*.ADSL.neobee.net.

Jabber: fedya@elitesecurity.org
Sajt: www.ammado.com

Profil

Re: SELECT * (kako odvajati posle jedan po jedan zapis)

^{27.09.2006. u 14:12}

Code:

INSERT INTO temp1
SELECT * FROM registrants

Ako ti je redosled kolona isti u temp1 i registrants ovo MORA da radi. Ako nisi siguran da li je redosled isti napisi kolone u upitu.

(napominjem da nisam detaljno gledao kod koji si poslao... to sigurno moze malo lepse da se napise...)

while ( ! ( succeed = try() ) );
--
Does the little mermaid wear an algaebra?

^{27.09.2006. u 14:12}

logic_rabbit
Radenko Zec
banjaluka

Član broj: 74458
Poruke: 183
*.lanaco.com.

Sajt: www.developers.ba

Profil

Re: SELECT * (kako odvajati posle jedan po jedan zapis)

^{27.09.2006. u 14:45}

Citat:

VerbatimBOT: Imam sledeći trigger:

Code:

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

MISLIM da ovdje treba>
umesto

Code:

UPDATE temp1
SET settlementID = @settlementID, jkdID = @jkdID, naceID = @naceID, ownershipID = @ownershipID, formID = @formID, agencyID = @agencyID
WHERE registrantID = @registrantID

Code:

UPDATE registrants
SET settlementID = @settlementID, jkdID = @jkdID, naceID = @naceID, ownershipID = @ownershipID, formID = @formID, agencyID = @agencyID
WHERE registrantID = @registrantID

Dalje taj select bi trebao za radi,ovdje nema potrebe za fetchom.Mozda da malo bolje to opises.

logic_rabbit (MCAD,MCSD,MCT,MCTS-Windows development,MCPD)
www.sqlpass.rs.ba

^{27.09.2006. u 14:45}