daytrades march 18 morning ..., page-172

hey Beechmere AKA Mr DBA.

i do daily extractions of all announcements.

would you like a time frame?

select top 50 Upper(Securitycode) + ' ', Headline, Createdate from announcements where headline like '%pleased%'
--and CreateDate > DATEADD(day,-12,GetDate())

--and CreateDate < DATEADD(day,-15,GetDate())
--and CreateDate > DATEADD(day,-35,GetDate())
--and pricesensitive = 1
order by createdate desc

tell ya what beech.
I ll let you modify the query for yourself.
Repost me what you want.

"Please" had no records.