You are right. It copied the events within 2018, but left out the events after and before. The other records are still stored in the other table. each of the caseIDs have events, every event have a timestamp. Some events might start in 2017, and end in 2018, some start and end in 2018. I want to pick out only those starting and ending in same year, 2018, and store them in a new table EDIT: Running the following code did only result in not selecting the events outside of 2018, the case is kept with less activities than before, when I want that case not to be kept as it has an event outside of 2018. where year(datepart(event_time_timestamp))= 2018
... View more