select dateDiff(d,eventStartDate,eventEndDate) days, * from tbl_EVT_Events e left outer join tbl_EVT_EventDates ed on e.eventID = ed.eventID where ed.eventDateId is NULL --and e.eventStartDate <> e.eventEndDate and dateDiff(d,eventStartDate,eventEndDate) < 8 -- and e.eventid = 96 insert into tbl_EVT_EVentDates(eventId, eventDay, eventDate, startTime, startTimePeriod, endTime, endTimePeriod) values ( , '#i#', , null, null, null, null) insert into tbl_EVT_EVentDates(eventId, eventDay, eventDate, startTime, startTimePeriod, endTime, endTimePeriod) values ( , '1', , null, null, null, null) insert into tbl_EVT_EVentDates(eventId, eventDay, eventDate, startTime, startTimePeriod, endTime, endTimePeriod) values ( , '1', , null, null, null, null) --->