select * from credit_card_order order by date_entered desc

update credit_card_order
set website_id=2
where date_entered > '10/22/2007'


select * 
from credit_card_order a, advertiser_tracking b
where website_id=2 and a.ip=b.ip and



GetOrdersPerAdvertiser '11/14/2007',2

p_get_advertiser_leads_per_date '11/15/2007',2



SELECT a.advertiser_id,b.advertiser_n, Count(a.advertiser_id) AS CountOfadvertiser_id, Count(c.credit_card_order_id) as NumOrders
FROM advertiser_tracking a INNER JOIN advertiser b 
		ON a.advertiser_id = b.advertiser_id 
	left outer join credit_card_order c
		on a.ip=c.ip and c.date_entered<='11/13/2007' and c.date_entered>='11/1/2007'
WHERE b.website_id = 2 
GROUP BY a.advertiser_id, b.advertiser_n,CONVERT(varchar, a.date_stamp, 101)
HAVING CONVERT(varchar, a.date_stamp, 101)<=CONVERT(varchar, '11/13/2007', 101) and CONVERT(varchar, a.date_stamp, 101)>=CONVERT(varchar, '11/1/2007', 101)
GO

select distinct b.advertiser_n, count(c.credit_card_order_id) as numOrders
from advertiser b  left outer JOIN  advertiser_tracking a 
		ON b.advertiser_id = a.advertiser_id 
	left outer join credit_card_order c
		on a.ip=c.ip
where b.website_id=2 and c.date_entered<='11/13/2007' and c.date_entered>='11/1/2007'
group by b.advertiser_n

GetAdvertiserPerformance '11/1/2007','11/15/2007'