i need to get dates from 01-11-2013 to 30-11-2013 for windows application in sql 2005...to design crystal report..how can i give query....please give as soon as possible...not only select query ,should sum up of certain qty and amount but also these should insert into a table