SQLServerCentral / SQL Server 2008 / SQL Server Newbies / Check Datetime Existence within multiple columns / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 15:35:24 GMT20RE: Check Datetime Existence within multiple columnshttp://www.sqlservercentral.com/Forums/Topic1410489-1292-1.aspxYou cannot mark them as answered on SSC, as it is primarily a discussion forum so topics are open for all to see and people may come back with their own take on how to solve your problem.Wed, 23 Jan 2013 06:00:19 GMTanthony.greenRE: Check Datetime Existence within multiple columnshttp://www.sqlservercentral.com/Forums/Topic1410489-1292-1.aspxThank you so much Tunnel.I've tried it and its working fine.How can I mark your post as an answer?Wed, 23 Jan 2013 05:58:24 GMTadnan8t2RE: Check Datetime Existence within multiple columnshttp://www.sqlservercentral.com/Forums/Topic1410489-1292-1.aspxPlease take a moment to read through the second link in my signature on posting code and data for the best help.But based on your post, you need something like this[cod="sql"]DECLARE @Bill TABLE (BillDate DATETIME, Mark BIT)INSERT INTO @Bill VALUES('2012-11-10 11:15:30',0),('2012-12-12 09:00:00',0)DECLARE @Dates TABLE (FromDate DATETIME, ToDate DATETIME)INSERT INTO @Dates VALUES('2012-11-01 07:00:00','2012-11-09 23:59:59'),('2012-12-08 07:00:00','2012-12-15 23:59:59')UPDATE BSET Mark = 1FROM @Bill BINNER JOIN @Dates d ON b.BillDate >= d.FromDate AND b.BillDate <= d.ToDateSELECT * FROM @Bill[/code]Wed, 23 Jan 2013 05:48:38 GMTanthony.greenCheck Datetime Existence within multiple columnshttp://www.sqlservercentral.com/Forums/Topic1410489-1292-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:05:24 GMTadnan8t2