How to select data with some of between in sql server 2008? -

How to select data with some of between in sql server 2008? -

in case have 2 table. 1 sales table , other event table.

the sales table:

date item qty 2014-10-01 2 2014-10-01 b 3 2014-10-05 5 2014-10-10 2 2014-10-11 2 2014-10-19 3 2014-10-19 b 6 2014-10-25 2 2014-10-25 b 1 2014-10-30 b 4

and event table:

event begin_date end_date holiday 2014-10-01 2014-10-03 holiday 2014-10-10 2014-10-13 month sale 2014-10-29 2014-10-30

how can select sales in event period?

in example, holiday event result this:

date item qty 2014-10-01 2 2014-10-01 b 3 2014-10-10 2 2014-10-11 2

the reply posted few mins removed himself. checked on same working. (same reply except distinct keyword)

select a.* #sales bring together #event b on a.mydate between b.begin_date , b.end_date b.event = 'holiday'

sql-server sql-server-2008 select sql-server-2008-r2 between