SET @qry=@qry+char(13)+	' 
	select largeName,materialCode,cmsMaterialCode,materialName,dimension,unitName,qty,price,buyingTotal,buyingAmt,buyingVat,isBuyingVat,largeCode
		from(select
		DBO.UF_LARGENAME(b.dealercode,b.largeCode) as largeName,
		b.materialCode,
		b.materialName,
		b.dimension ,
		DBO.UF_UNITNAME(b.unitCode) as unitName ,
		SUM(a.materialQty-a.rtnQty) as qty,

		(case when a.isBuyingVat=''Y'' then
			dbo.UF_MCVT2(round(SUM(a.buyingAmt)/(case when SUM(a.materialQty-a.rtnQty)=0 then 1 else SUM(a.materialQty-a.rtnQty) end),0),0,0) 
		else 
			dbo.UF_MCVT2(round(SUM(a.buyingAmt+a.buyingVat)/(case when SUM(a.materialQty-a.rtnQty) = 0 then 1 else SUM(a.materialQty-a.rtnQty) end),0),0,0) 
		end ) as price,
		SUM(a.buyingAmt + a.buyingVat) as buyingTotal,
		SUM(a.buyingAmt) as buyingAmt,
		SUM(a.buyingVat) as buyingVat,
		isNull(b.cmsMaterialCode,'''') as cmsMaterialCode,
		a.isBuyingVat,
		b.largeCode
	from orders a,material b
	where a.dealerCode='''+@A_dealerCode+''' 
	and a.stockinDay between '''+@A_startDay+''' and '''+@A_endDay+''' 
	'

''''''
SET @qry=@qry+char(13)+	'  group by b.dealerCode,b.largeCode,b.materialCode,b.materialName,b.dimension,b.unitCode,b.cmsMaterialCode,a.isbuyingVat '
		
	set @qry = @qry +' 	union all 	'
 	set @qry = @qry +' 	select  ''소계'','''','''','''','''',SUM(a.materialQty-a.rtnQty) as qty,0	'
	set @qry = @qry +' 			,SUM(a.buyingAmt + a.buyingVat) as buyingTotal, SUM(a.buyingAmt) as buyingAmt,	'
	set @qry = @qry +' 			SUM(a.buyingVat) as buyingVat,'''',''''	,''''
								from orders a,material b
								where a.dealerCode='''+@A_dealerCode+''' 
								and a.stockinDay between '''+@A_startDay+''' and '''+@A_endDay+''' '

''''''
SET @qry=@qry+char(13)+	'  group by DBO.UF_LARGENAME(b.dealercode,b.largeCode) '
	set @qry = @qry +' 	union all 	'
 	set @qry = @qry +' 	select  ''총계'','''','''','''','''',SUM(a.materialQty-a.rtnQty) as qty,0	'
	set @qry = @qry +' 			,SUM(a.buyingAmt + a.buyingVat) as buyingTotal, SUM(a.buyingAmt) as buyingAmt,	'
	set @qry = @qry +' 			SUM(a.buyingVat) as buyingVat,'''','''',''''	
								from orders a,material b 		'
	set @qry = @qry +' 	where a.dealerCode='''+@A_dealerCode+''' '
	set @qry = @qry +'  and a.stockinDay between '''+@A_startDay+''' and '''+@A_endDay+'''
 )f '
	set @qry = @qry +' 	order by f.materialName ' 

이런식으로 짜서 사진처럼 소계총계가 앞으로 튀어나오더라구요

소계는 안쪽으로넣고 총계는 맨밑으로빼고싶은데 방법이 있을까요??