Check Datetime Existence within multiple columns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Check Datetime Existence within multiple...

Check Datetime Existence within multiple columns

Rate Topic

Display Mode

Topic Options

Author

Message

adnan8t2

Posted Wednesday, January 23, 2013 5:06 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 5:55 AM
Points: 9, Visits: 9

Hi 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 & 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

I hope I've explained my scenario,

Post #1410490

Bhuvnesh

Posted Wednesday, January 23, 2013 5:20 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

Dont cross post.. it wastes time of other people.

Original post here http://www.sqlservercentral.com/Forums/Topic1410489-1292-1.aspx

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1410499

« Prev Topic | Next Topic »

Permissions