sql server - Why isn't my nested SQL SELECT INTO statement working? -

the basic select statement works, need transactionnumbers in table date in table equal whatever setup new table doesn't transactionnumbers. how this? helping!

query = select * [bos_primary_db2].dbo.[tenderentry] [bos_primary_db].dbo.[tenderentry]  [tenderentry].transactionnumber in            (select transactionnumber            [bos_primary_db.dbo].[transaction]            [transaction].date >= '2012-2-2'                            , [transaction].date < '2012-2-3') 

you can try this:

[transaction].date between '2012-02-02' , '2012-02-03'