SELECT * FROM tablename where insertdate BETWEEN @startDate and @endDate this is simple but it won't contain @endDate in result set. For that you need to use DATEADD(datepart, number, date) fuction Since your query will be SELECT * FROM tablename WHERE insertdate BETWEEN @startDate and DATEADD(d,1,@endDate) Thanks, Vishal K