THat did the trick! THanks!

What I am trying to accomplish is to call [dbo].[i14_get_ids] for each row insert, where the number of inserts could be 1 or n, and write the output of that...

A software program called "ArcGIS" is used to insert/edit rows in tbl_locations. ArcGIS is a mapping program, and manipulates data in a spatial environment. When a new "location" is create...

It's not working for multiple row inserts. The record source for tbl_locations is ArcGIS. When one "record" is created with ArcGIS, a corresponding record is created in tbl_events just fine....

how would that change to handle multirow inserts? Thanks

CREATE TABLE [dbo].[tbl_Events](

[Event_ID] [uniqueidentifier] NOT NULL,

[Location_ID] [uniqueidentifier] NULL,

[Event_Group_ID] [uniqueidentifier] NULL,

[Protocol_Name] [nvarchar](100) NULL,

[Start_Date] [datetime2](0) NULL,

[Start_Time] [datetime2](0) NULL,

[Entered_Date] [datetime2](0) NULL,

[Date_Precision] [nvarchar](50) NULL,

[SpeciesID_Observation] [nvarchar](50) NULL,

[Entered_By] [nvarchar](50) NULL,

[Observation] [nvarchar](max) NULL,

[SpeciesID] [nvarchar](20) NULL,

[Species_ID] [int] NULL,

[OBJECTID]...