C# code: INSERT INTO #Oldfencemytable (oldfence_name, animal_id) SELECT OldFence_Name, Animal_Id from TBL_AnimalMove WHERE (Animal_Id IN (SELECT animal_id from #mytable)) AND (OpTime IS NOT NULL) AND (OpTime IN (SELECT MIN(optime) from tbl_animalmove WHERE animal_id IN (SELECT animal_id from #mytable) AND optime IS NOT NULL GROUP BY animal_id))
