InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:39:37 GMT20http://www.sqlservercentral.com/Forums/Topic602011-1418-1.aspxplease see the link below to help us figure out what's going on. Sample DDL and data will help us to solve your issues faster. Thanks,Jon[url]http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]Fri, 14 Nov 2008 06:19:54 GMTjcrawf02http://www.sqlservercentral.com/Forums/Topic602011-1418-1.aspxHi Members,Im doing a select in which im specifying the date range.."select key_id from result where started_at_date >= '2008-10-17 13:30:00' and ended_at_date <= '2008-10-17 13:30:20'"but in the above query im getting the key_id for which the date range is out of the date range specified here.That is im getting key_id = 5, for whcih started_at = '2008-10-18 13:30:00' and ended_at = '2008-10-18 13:30:20'Please help me to solve this issue.Regards,Prabhu.Thu, 13 Nov 2008 05:44:08 GMTprabhu.rangan