Meppy, I have the following code (I have also used the Mark Exception with no luck)
If con.State = ConnectionState.Closed Then con.Open()
My_SQL_Sub("Insert Into Item([Task],[StartTime],[EndTime],[AllDayEvent],[HeaderText],_
[DescriptionText],[ImageIndex],[Id],[Locked],[Reminder],[Recurrence],[RecurrenceState],[OccurrenceIndex],[Priority],[Style],[SelectedStyle],[Visible],[Tag],_
[PointedStyle],[PointedSelectedStyle],[AllowChangeStart],[AllowChangeEnd],[AllowMove], [PlannedDuration], [Area], _[Team], [Crew]) Select [Task],CONVERT(datetime,'" & Format(e.Item.StartTime, "yyyy-MM-ddTHH:mm:ss") & "'),_
CONVERT(datetime,'" & Format(e.Item.EndTime, "yyyy-MM-ddTHH:mm:ss") & "'),[AllDayEvent],[HeaderText],[DescriptionText],_
[ImageIndex],[Id],[Locked],[Reminder],[Recurrence],'2', '" & e.Item.OccurrenceIndex & "' ,[Priority],[Style],[SelectedStyle],[Visible],[Tag],[PointedStyle],[PointedSelectedStyle],[AllowChangeStart],_
[AllowChangeEnd],[AllowMove], [PlannedDuration], [Area],_
[Team], [Crew] From Item Where [Key] = (Select [Key] From Item Where ID = '" & e.Item.Id & "' AND [RecurrenceState] = 3) Declare @MasterKey int Set @MasterKey = (Select scope_identity()) Insert Into [RecurrenceException] ([Item], [IsDeleted], [Index], _
[Team]) Values (@MasterKey, 'True','" & e.Item.OccurrenceIndex & "', '" & pTeam & "') Declare @NewKey int Set @NewKey = (Select scope_identity()) Insert Into [RecurrenceExceptions] ([Recurrence], _
[Exception], [Team]) (Select [Key], @NewKey, '" & pTeam & "' From Recurrence Where [Master] = (Select [Key] From Item Where ID = '" & e.Item.Id & "' AND [RecurrenceState] = 3))", , , True)
If con.State = ConnectionState.Open Then con.Close()
All this code does is insert new rows into the "Item", "RecurrenceException" and "RecurrenceExceptions" Tables. I have confirmed this enters the correct data into the database.