Hi!

Its depended on what you're goind to do in that processing SP. Certaing things could be done without creating cursor. If you know for sure what that SP do, try to throw it here to see if it possible to change what that SP do for each record to convert it to the processing of all records without cursor.

>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..."