select 
		case 1 when GROUPING(a.dealerCode) THEN '총계' WHEN GROUPING(a.storeCode) then '소계' else a.stockinday end as stockinday, 
		isNull(case when a.storeCode != '9999' then a.storeCode else a.refStoreCode end,'') as storeCode, 
		isNull(case when a.storeCode != '9999' then DBO.UF_STORENAME(a.dealerCode,a.storeCode) else  DBO.UF_STORENAME(a.dealerCode,a.refstoreCode) end,'') as storeName, 
		isNull(mat.materialCode,'') as materialCode, 
		isNull(mat.materialName,'') as materialName, 
		isNull(a.refStockInDay,'') as refstockinday, 
		isNull(a.refMaterialCode,'') as refMaterialCode, 
		isNull(DBO.UF_MaterialName(a.dealerCode,a.refMaterialCode),'') as refmaterialName, 
		isNull(mat.dimension,'') as dimension, 
		mat.domesticText, 
		isNull(DBO.UF_UnitName(mat.unitCode),'') as unitName, 
		DBO.UF_ReportNumericConvert(a.dealerCode,a.materialQty) as materialQty, 
		DBO.UF_ReportNumericConvert(a.dealerCode,a.rtnQty) as rtnQty, 
		a.buyingPrice, 
		sum(a.buyingAmt + a.buyingVat) as buyingTotal, 
		sum(a.buyingAmt), 
		sum(a.buyingVat), 
		a.sellingPrice, 
		sum(a.sellingAmt + a.sellingVat) as sellingTotal, 
		sum(a.sellingAmt), 
		sum(a.sellingVat), 
		sum((a.buyingAmt + a.buyingVat) - (a.sellingAmt + a.sellingVat)) as interest,   
		dbo.UF_MCVT2(dbo.uf_dealerOption_Rate('1001',(a.buyingAmt + a.buyingVat),(a.sellingAmt + a.sellingVat)),0,2) as rate,   
		isNull(a.remark,'') as remark 
	from orders a,material mat 
	where a.dealerCode='1001' 
	and a.stockinDay between '20140401' and '20140402' 
	and a.dealerCode=mat.dealerCode 
	and a.materialCode=mat.materialCode 
	and a.iswarehouse <> 'X' 
 group by rollup((a.stockinday,a.dealerCode),(a.storeCode,a.buyingAmt,a.buyingVat,a.sellingAmt,a.sellingVat,mat.materialCode,mat.materialName,a.refStoreCode,a.refStockInDay,a.refMaterialCode,mat.dimension,mat.domesticText,mat.unitcode,a.materialqty,a.rtnqty,a.buyingprice,a.sellingprice,a.remark)) 

stockinday    storeCode    storeName    materialCode    materialName
20140401    2001    산업체1    1000112    감자(왕특)
20140401    2005    거래처    1000070    고추(꽈리,상)
20140401    2005    거래처    1000221    마늘(간,상)
20140401    2005    거래처    1001563    냉동꼬마당근(수입,1K)
20140401    2005    거래처    1002671    깐대파(kg)
20140401    2005    거래처    1000111    감자(깐,손)
20140401    2005    거래처    1002675    깐양파(1KG)-직송
20140401    2005    거래처    1000119    무(알타리)
20140401    2005    거래처    1002515    쑥갓
20140401    2005    거래처    1002240    감자(깐,기계,120g)％
20140401    2124    명신여고    1000111    감자(깐,손)
20140401    2001    산업체1    1000112    감자(왕특)
20140401    2005    거래처    1000111    감자(깐,손)
소계                
20140402    2005    거래처    1000237    생강(깐,국산)
20140402    2005    거래처    1002671    깐대파(kg)
20140402    2005    거래처    1000221    마늘(간,상)
20140402    2005    거래처    1000036    부추(중국)
20140402    2005    거래처    1001563    냉동꼬마당근(수입,1K)
20140402    2005    거래처    1000051    냉이
20140402    2005    거래처    1000239    대파
20140402    2005    거래처    1002675    깐양파(1KG)-직송
20140402    2005    거래처    1000055    배추
20140402    2005    거래처    1002240    감자(깐,기계,120g)％
20140402    2124    명신여고    1000111    감자(깐,손)
소계                
총계                

stockinday -> storecode 순으로 정렬하고싶은데 자꾸 소계총계가 깨집니다 방법이있을까요??