InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:10:10 GMT20http://www.sqlservercentral.com/Forums/Topic1410490-149-1.aspxDont cross post.. it wastes time of other people. Original post here [url]http://www.sqlservercentral.com/Forums/Topic1410489-1292-1.aspx[/url]Wed, 23 Jan 2013 05:20:59 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1410490-149-1.aspxHi there,I've a BillDate as date, and a Mark as bit column in First table.(Mark=0 by default)In Second table I've FromDate as date, and ToDate as date Column.I want to set Mark=1 if BillDate is exists between FromDate & ToDateLet Say In First Table the data is----------------------------BillDate | Mark----------------------------2012-11-10 11:15:30 | 02012-12-12 09:00:00 | 0In Second Table the data is---------------------------------------------FromDate | ToDate---------------------------------------------2012-11-01 07:00:00 | 2012-11-09 23:59:592012-12-08 07:00:00 | 2012-12-15 23:59:59So in the above scenario only the second row from First tablewhich is having, BillDate->2012-12-12 09:00:00 will be Mark as 1because it comes between second row of second tableI hope I've explained my scenario,Wed, 23 Jan 2013 05:06:39 GMTadnan8t2