EXEC	transform 'S'
EXEC	transform 'W','S','SELECT	"Store"=st.stor_name,"Row_Summary"=Sum(qty)'                                                                                                                                                                               
EXEC	transform 'W','F','FROM		pubs..sales s, pubs..titleauthor ta , pubs..stores st ,pubs..authors a ,pubs..titles t'                                                                                                                                                                                                         
EXEC	transform 'W','W',"WHERE	ord_date > '1 aug 1991'  "
EXEC	transform 'W','W','AND		a.au_id=ta.au_id'
EXEC	transform 'W','W','AND		ta.title_id=t.title_id'
EXEC	transform 'W','W','AND		t.title_id=s.title_id'
EXEC	transform 'W','W','AND		st.stor_id=s.stor_id'

EXEC	transform 'W','G','GROUP BY	st.stor_name'

EXEC	transform 'T',
	@agg_function ='SUM',
	@agg_expresion ='qty',
	@Pivot_field ='a.au_fname',
	@Pivot_values=null,
	@debug=1,
	@op_table='common..ae_pubs_xtab',
	@Pivot_order='FD',
	@pivot_columns=7,
	@pivot_remainder='The others'
	
EXEC	("SELECT * from common..ae_pubs_xtab ")

go
/*
EXEC	transform 'S'
EXEC	transform 'W','S','SELECT	stor_id,"Row_Summary"=Sum(qty)'                                                                                                                                                                               
EXEC	transform 'W','F','FROM		pubs..sales s, pubs..titles t , pubs..publishers p '                                                                                                                                                                                                         
EXEC	transform 'W','W','WHERE	ord_date > "1 aug 1991"  '
EXEC	transform 'W','W','AND		s.title_id=t.title_id'
EXEC	transform 'W','W','AND		t.pub_id=p.pub_id'
EXEC	transform 'W','W','AND		t.pub_id=p.pub_id'
EXEC	transform 'W','G','GROUP BY	stor_id'

EXEC	transform 'T',
	@agg_function ='SUM',
	@agg_expresion ='qty',
	@Pivot_field ='p.pub_name',
	@Pivot_values=null,
	@debug=1,
	@op_table='common..ae_pubs_xtab',
	@Pivot_order='FD',
	@pivot_columns=7,
	@pivot_remainder='The others'
	
EXEC	("SELECT * from common..ae_pubs_xtab ")

*/