You can modify your stored procedure so you can request not only single key but multiple keys (range of keys). In the trigger you can than request range of keys and use it to populate multiple records.

>Hi Sergey
>
>Thanks for replying Sergey.
>
>I've tried using a trigger (I need to call my sp called pkGen which calculated the next pk for the table). But the trigger seems only to be called once during the insert rather than for every row (the insert is doing a bulk insert via a select).
>
>
>Regards
>
>Kal