with result as ( select top #_top# partnerName, partnerType, partnerId, partnerTk, sum( rolling12ClaimVolume ) rolling12ClaimVolume, sum( rolling12AgreementVolume ) rolling12AgreementVolume from tbl_DW_AgreementAnalyzer_#_tableSuffix# with (nolock) where partnerType = and territoryId in ( ) and ( 1 = 2 or territoryPath like ) and businessOwnerUserId in ( ) and territoryId in ( ) and not ( partnerName like '%blanket%' or contractName like '%blanket%' ) and coalesce(partnerCompanyType,'') <> 'G' group by partnerName, partnerType, partnerId, partnerTk having sum( #_by# ) > 0 order by #_by# desc ) select * from result order by #_by# desc for json auto, include_null_values