title: get data in sql from from date to to date
body: <p>I want to write the stored procedure which would give me the data within the rage of date. I can not use 'Between'  , it is giving data between the range , i need within the range means from 1-jan-2011 to 30-jan-2011 (data of 30 jan must be included) how to do this with query/ SP</p>