Please 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

B

SET

Mark = 1

FROM

@bill B

INNER JOIN

@Dates d

ON

b.BillDate >= d.FromDate

AND

b.BillDate <= d.ToDate

SELECT * FROM @bill

[/code]