ENGINE SQLMSS SET DEFAULT_CONNECTION COMPASS
SQL SQLMSS PREPARE SQLOUT FOR
select case when b.parentagencyid is not null then b.parentagencyid else b.agencyid end as agencyid,
	a.supplierid as supplierid, sum(salesPrev3) as salesPrev3, sum(salesPrev2)as salesPrev2,
	sum (salesPrev1) as salesPrev1,sum(salesCurMth) as salesCurMth, sum(salescurytd) as salescurytd,
	sum(salesTvlCurYr)as salesTvlCurYr,sum(salesOTBCurYr)as salesOTBCurYr,sum(salesOTBCurYr) as salesOTBCurYr,
	sum (salesCurMthLY) as salesCurMthLY, sum (salesYTDLY) as salesYTDLY, max(agencylastyrmth) as agencylastyrmth
from webfocus_report_sales_by_supplier a, agency_v b
where a.agencyid = b.agencyid
group by case when b.parentagencyid is not null then b.parentagencyid else b.agencyid end,
	 a.supplierid
order by case when b.parentagencyid is not null then b.parentagencyid else b.agencyid end
;
END
TABLE FILE SQLOUT
PRINT *
ON TABLE PCHOLD AS KFRR
END
-RUN  

quote:

get it to come up Table list