I believe that's the only alternative. Cursors are the only thing AFAIK, that can deal with singular records.
One question is why you need to do this. Can't you send the data through your SP and have that actually do the INSERT? That way the SP processing occurs before the trigger code.
>Hello!...
>
>I've a trigger where I want to process all the INSERTED table in an instruction only ( like an Insert Into Table1 Frmo Inserted), but I need to process each record with a SP.
>It's the only chance to create a cursor from the INSERTED table an process one record at the time.?!
>If not.. uff.. what's the answer then?
>
>Thanks Friends!
>Bye...
>Manuel Almeida
>
>The rule of knowledge:
>"I only know that I know nothing..."
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao