select * from tempTable
where (@begininsertdate >= convert(varchar(10),Fs_BeginTime,120) and @begininsertdate <= convert(varchar(10),Fs_EndTime,120)) or
(@endinsertdate >= convert(varchar(10),Fs_BeginTime,120) and @endinsertdate <= convert(varchar(10),Fs_EndTime,120))