SELECT	a.[date] as iDate,
	SUM(a.struck_stake) as struck_stakes,
	sum(a.struck_stake)-sum(settled_returns) as GP
FROM
	AGG1.dbo.AGG_DAY_009 as a
inner join WHouse1.dbo.Date_Dim as b
	on b.date_key = a.DATE
inner join WHouse1.dbo.COST_CENTRE_DIM as c
	on c.COST_CENTRE_NUMBER = a.COST_CENTRE_NUMBER
WHERE	c.CURRENT_FLAG = 'C'
AND	a.Date  = 20051019 
AND	c.COST_CENTRE_NUMBER  =  2309
group by a.[date]

(select b.df1date as iDate, b.take as struck_stakes, b.adjustedGP as GP
from whouse1.dbo.date_dim as a
inner join whouse1.dbo.daily_figures_fact as b
	on a.date_key = b.df1date
inner join whouse1.dbo.cost_centre_dim as c
	on c.cost_centre_code = b.shop
where	(c.current_flag = 'c' or c.current_flag = 'x')
and	b.df_username <> 'system'
and	c.cost_centre_code = 2309
and	a.date_key = 20051019)