Welcome to Sign in | Help

Re: trigger de INSERT,UPDATE - SQL Server 2000

  •  06-25-2007, 3:20 PM

    Re: trigger de INSERT,UPDATE - SQL Server 2000

    ceva este gresit....dar nu-mi dau seama ce......ce ar mai trebui facut?...ceva sugestii?....daca fac un insert pe tabela respectiva imi da o eroare

    "Server: Msg 925, Level 19, State 1, Procedure trg_Equival_INSERT_UPDATE, Line 14
    Maximum number of databases used for each query has been exceeded. The maximum allowed is 8.

    Connection Broken"

    asta e triggerul...asa cum m-am priceput eu :)

    CREATE TRIGGER [trg_Equival_INSERT_UPDATE] ON [dbo].[EQUIVAL]
    FOR INSERT,UPDATE
    AS

    if trigger_nestlevel(object_id(N'[dbo].[trg_Equival_INSERT_UPDATE]'))=1
    --if @@rowcount = 0 return
    declare @CURIDREF as int ,
     @RATEDATE as datetime ,
     @CURID as int

    select @CURIDREF = curidref, @RATEDATE = ratedate, @CURID = curid from inserted

    If Not Exists(SELECT * FROM DBName..EQUIVAL WHERE curidref=@CURIDREF AND
    ratedate = @RATEDATE AND curid = @CURID)

     begin
      insert into DBName..EQUIVAL (curidref,ratedate,curid,purchaserate,fixingrate,salesrate)
      select curidref,ratedate,curid,purchaserate,fixingrate,salesrate from inserted
      
      -- se mai adauga inca un database

     end
    else
     begin
      update a
      set a.purchaserate = i.purchaserate, a.fixingrate = i.fixingrate, a.salesrate = i.salesrate
      from DBName..EQUIVAL a, inserted i
      where a.curidref = @curidref and a.ratedate = @ratedate and a.curid = @curid
     
      -- se mai adauga inca un database

     end

    GO

    alex.

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems