---> ---> insert into tbl_OPR_FieldValues (FieldID,PartnerID,PartnerType,Data,ValueIndex) values (, ,'OPR',,1) ---> declare @dateTable as table( data datetime); insert into @dateTable ( data ) select convert( datetime, fv.data ) from tbl_OPR_FieldValues fv with (nolock) inner join tbl_OPR_Fields f with (nolock) on f.fieldId = fv.fieldId and f.ownerId = 26 and f.ownerType = 'MFR' where fv.partnerType = 'OPR' and f.name ='NCD' and isDate( fv.data ) = 1; select * from @dateTable where data between '05/01/2020' and '09/15/2020'