SELECT ID, AgentID, ProjectID, FirstName, LastName, Email, BlueTotal, RedTotal, GreenTotal, YellowTotal, PrimaryColor, ColorAssigned, GroupAssigned FROM participants WHERE ActionFlag = 1 INSERT INTO teams (ID, AgentID, TeamName, TeamCode, DateCreated, ContactFirstName, ContactLastName, ContactEmail, ContactPhoneNumber, TeamType, NotifyAOnEval, NotifyCOnEval, MemberCount ) VALUES ('#Tmp#', '#Client.AgentID#', '#Client.TeamCreate_TeamName#', '#Client.TeamCreate_TeamCode#', #CreateODBCDate(Now())#, '#Client.TeamCreate_ContactFirstName#', '#Client.TeamCreate_ContactLastName#', '#Client.TeamCreate.ContactEmail#', '#Client.TeamCreate_ContactPhoneNumber#', '#Client.TeamCreate_TeamType#', #Client.TeamCreate_NotifyAOnEval#, #Client.TeamCreate_NotifyCOnEval#, #GetTeam.RecordCount# ) INSERT INTO teammembers (ID, AgentID, TeamID, TeamCode, ParticipantID, FirstName, LastName, Email, BlueTotal, RedTotal, GreenTotal, YellowTotal, PrimaryColor, ColorAssigned, GroupAssigned, DateCreated ) VALUES('#CreateUUID()#', '#Client.AgentID#', '#Tmp#', '#Client.TeamCreate_TeamCode#', '#GetTeam.ID#', '#GetTeam.FirstName#', '#GetTeam.LastName#', '#GetTeam.Email#', #GetTeam.BlueTotal#, #GetTeam.RedTotal#, #GetTeam.GreenTotal#, #GetTeam.YellowTotal#, '#GetTeam.PrimaryColor#', '#GetTeam.ColorAssigned#', '#GetTeam.GroupAssigned#', #CreateODBCDate(Now())# ) UPDATE participants SET ActionFlag = 0 temp = DeleteClientVariable("Client.TeamCreate_TeamName"); temp = DeleteClientVariable("Client.TeamCreate_ContactFirstName"); temp = DeleteClientVariable("Client.TeamCreate_ContactLastName"); temp = DeleteClientVariable("Client.TeamCreate_ContactPhoneNumber"); temp = DeleteClientVariable("Client.TeamCreate.ContactEmail"); temp = DeleteClientVariable("Client.TeamCreate_TeamType"); temp = DeleteClientVariable("Client.TeamCreate.NotifyCOnAssess"); temp = DeleteClientVariable("Client.TeamCreate.NotifyAOnAssess"); temp = DeleteClientVariable("Client.TeamProjectID"); temp = DeleteClientVariable("Client.TeamAction");