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 & ToDate
Let Say In First Table the data is ---------------------------- BillDate | Mark ---------------------------- 2012-11-10 11:15:30 | 0 2012-12-12 09:00:00 | 0
In Second Table the data is --------------------------------------------- FromDate | ToDate --------------------------------------------- 2012-11-01 07:00:00 | 2012-11-09 23:59:59 2012-12-08 07:00:00 | 2012-12-15 23:59:59
So in the above scenario only the second row from First table which is having, BillDate->2012-12-12 09:00:00 will be Mark as 1 because it comes between second row of second table
Check Datetime Existence within multiple columns
Posted - 01/23/2013 : 06:57:20
