select * into #productsku1 from TProductSku where ProductSkuId in (select productskuid from #productskuqty)select b.ProductType as silo,a.ClassId1,a.ClassId2,b.ClassName as classid3,a.ProductSkuId,ProductSkuName,c.qty into #productsku2 from #productsku1 a left join TProductClass3 b on a.ClassId3=b.ClassIdleft join #productskuqty c on a.ProductSkuId=c.ProductSkuIdselect silo,ClassId1,ClassId2 ,sum(qty) as qty from #productsku2group by silo,ClassId1,ClassId2order by silo,ClassId1,ClassId2
select silo,ClassId1,ClassId2,sum(qty) as qty,convert(varchar ,(sum(qty)/sum(qty))*100) +'%' as percen
into #productsku9
from #productsku2
group by silo,ClassId1,ClassId2
order by silo,ClassId1,ClassId2