CREATE procedure [wh].[p_PL_D2_S168TabellaEmittenti] (@Rete char(1), @CodiceFiscale varchar(16)) as  select top 999999 ProcedureName,i_rete,i_codiceFiscale,COD_FISCALE,RETE,RATING_AAA,RATING_AAp,RATING_AA,RATING_AAm,RATING_Ap,RATING_A,RATING_Am,RATING_BBBp,RATING_BBB,RATING_BBBm,RATING_BBp,RATING_BB,RATING_BBm,RATING_Bp,RATING_B,RATING_Bm,RATING_CCCp,RATING_CCC,RATING_CCCm,RATING_CC,RATING_C,RATING_D,RATING_na,FLG_RISKCLASS1,FLG_RISKCLASS2,FLG_RISKCLASS3,FLG_RISKCLASS4,FLG_RISKCLASS5,FLG_RISKCLASS6,FLG_RISKCLASS7,FLG_RISKCLASS8,FLG_RISKCLASS9,FLG_RISKCLASS10,INTERMEDIARIO,ISSUER,STOCKSCounterValue,bondsCounterValue,CONCENTRATION_ISSUER,CONCENTRATION,NC from wh.PL_D2_S168TabellaEmittenti
  where i_rete = @rete and i_codiceFiscale = @codiceFiscale  ORDER BY  CONCENTRATION DESC , CONCENTRATION_ISSUER DESC