SELECT 
 		case when GROUPING_ID(stockInDay,materialCode)='1' then '소계' 
									     when GROUPING_ID(stockInDay,materialCode)='3' then '총계'
									else stockInDay end as stockInDay,
       materialCode,                                    
       case when dimension is null and materialCode is not null then '소계' else materialName end materialName ,                             
       dimension,                             
       domesticText,                             
       sum(realQty) realQty,                            
       unitName,                              
       sellerCode,                             
       sellerName,                              
       storeCode,                             
       storeName,                             
       isSellingvat,                             
       sellingPrice,                            
       sum(sellingTotal) sellingTotal,                              
       sum(sellingAmt) sellingAmt,                             
       sum(sellingVat) sellingVat,                            
       remark,                            
       restrictCount,                             
       modifierDate,                            
       sellermaterialcode,                             
       remark2,                              
       handphone,                             
       address                             
 	FROM (
 	select 
 		a.stockInDay, 
 		a.materialCode, 
 		b.materialName, 
 		b.dimension, 
 		b.domesticText, 
 		a.materialQty-a.rtnQty as realQty, 
 		DBO.UF_UNITNAME(b.unitCode) as unitName, 
 		a.sellerCode, 
 		DBO.UF_SELLERNAME(a.dealerCode,a.sellercode) as sellerName, 
 		a.storeCode, 
 		case when a.storecode = '9999' then '창고입고' 
		else ( case when len(replace(a.storetype,' ',''))>0 then DBO.UF_STORENAME(a.dealerCode,a.storeCode)+'('+replace(a.storetype,' ','')+')' else DBO.UF_STORENAME(a.dealerCode,a.storeCode) end ) end as storeName, 
 		a.isSellingvat, 
 		a.sellingPrice, 
 		a.sellingAmt+a.sellingVat as sellingTotal, 
 		a.sellingAmt, 
 		a.sellingVat, 
 		a.remark, 
 		(case when a.orders_restrictcount is null then 'D-'+isnull(b.restrictCount,'1') else 'D-'+a.orders_restrictcount end) as restrictCount,	
 		a.modifierDate ,
 		b.sellermaterialcode, 
 		isnull(a.domesticText,'') as remark2, 
 		(select handphone from client where dealerCode='1713' and  clientCode=a.storeCode) as handphone, 
 		(select address   from client where dealerCode='1713' and  clientCode=a.storeCode) as address 
	from orders a,material b 
	where a.dealerCode='1713' 
	and a.dealerCode=b.dealerCode 
	and a.materialCode=b.materialCode 
	and a.stockinDay between '20220622' and '20220622' 
     and ((a.storeCode !='9999' and a.isWareHouse='D') or storeCode ='9999')
) t 
group by rollup((stockInDay),(sellerCode,sellerName,materialName,materialCode),(
																		
																	dimension,
																	domesticText,		
																	unitName,																		
																	storeCode,	
																	storeName,	
																	isSellingvat,	
																	sellingPrice,		
																	remark,	
																	restrictCount,	
																	modifierDate,	
																	sellermaterialcode,	
																	remark2,	
																	handphone,	
																	address)) 
  ORDER BY GROUPING(t.stockinday  ), t.stockinday
        , GROUPING(t.sellercode  ), t.sellercode
        , GROUPING(t.materialName), t.materialName
        , GROUPING(t.materialCode), t.materialCode 

쿼리문이구요.. 사진처럼 고기산적이 6개로 나와야하는데

어떤이유인진 몰라도 몇몇개가 합쳐져서 4개로 나옵니다.. 무슨현상인가요 ㅠㅠ

+원인은 찾았씁니다.. 결과값이 완전 똑같으면 합쳐지는 모양인데 이거 막을수있는 방법이 있을까요