SELECT TRAN_SCINTERESTEDCOURSES.TrainerId,TRAN_SCINTERESTEDCOURSES.coursesdate,TRAN_SCINTERESTEDCOURSES.courseedate,TRAN_SCINTERESTEDCOURSES.LocationId,MST_LOCATION.LocationName from TRAN_SCINTERESTEDCOURSES
inner join MST_LOCATION on TRAN_SCINTERESTEDCOURSES.LocationId = MST_LOCATION.LocationId where TrainerId is not null
and CONVERT(datetime,'2016-05-01')
between DATEADD(month, DATEDIFF(month, 0, CourseSDate), 0)
and DATEADD(month, DATEDIFF(month, 0, CourseEDate), 0)
inner join MST_LOCATION on TRAN_SCINTERESTEDCOURSES.LocationId = MST_LOCATION.LocationId where TrainerId is not null
and CONVERT(datetime,'2016-05-01')
between DATEADD(month, DATEDIFF(month, 0, CourseSDate), 0)
and DATEADD(month, DATEDIFF(month, 0, CourseEDate), 0)
No comments:
Post a Comment