pivot dessas tabelas,alguem ai sab como fazer?:?

[Mr Crowley 0]

--adimplentesSELECT     Cod_Mun AS Cidade, COUNT_BIG (N_Op_Imp) AS N_Contratos, SUM(Val_Op_Emp) AS Valor_TotalFROM         ContratosWHERE     (Linha_Final = 'A') AND (N_Pri_Pres = 0)GROUP BY Cod_MunORDER BY Cod_Mun--30 diasSELECT     Cod_Mun AS Cidade_30, COUNT_BIG (N_Op_Imp) AS N_Contratos_30, SUM(Val_Op_Emp) AS Valor_Total_30FROM         ContratosWHERE     (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) BETWEEN 1 AND 30)GROUP BY Cod_MunORDER BY Cod_Mun--31 ate 90 diasSELECT     Cod_Mun AS Cidade, COUNT_BIG (N_Op_Imp) AS N_Contratos, SUM(Val_Op_Emp) AS Valor_TotalFROM         ContratosWHERE     (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) BETWEEN 31 AND 90)GROUP BY Cod_MunORDER BY Cod_Mun--+90 diasSELECT     Cod_Mun AS Cidade, COUNT_BIG (N_Op_Imp) AS N_Contratos, SUM(Val_Op_Emp) AS Valor_TotalFROM         ContratosWHERE     (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) > 90)GROUP BY Cod_MunORDER BY Cod_Mun

bem preciso desses 4 resultado juntos

alguem ai pode me dar uma lux?

[alpoimpm 0]

Olá,Será qq coisa deste género:SELECT Cod_Mun AS Cidade, COUNT_BIG(CASE WHEN (Linha_Final = 'A') AND (N_Pri_Pres = 0) THEN N_Op_Imp ELSE 0 END) AS Adimplentes_Count, SUM(CASE WHEN (Linha_Final = 'A') AND (N_Pri_Pres = 0) THEN Val_Op_Emp ELSE 0 END) AS Adimplentes_Sum, COUNT_BIG(CASE WHEN (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) BETWEEN 1 AND 30) THEN N_Op_Imp ELSE 0 END) AS [30 Dias_Count], SUM(CASE WHEN (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) BETWEEN 1 AND 30) THEN Val_Op_Emp ELSE 0 END) AS [30 Dias_Sum], COUNT_BIG(CASE WHEN (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) BETWEEN 31 AND 90) THEN N_Op_Imp ELSE 0 END) AS [30-90 Dias_Count], SUM(CASE WHEN (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) BETWEEN 31 AND 90) THEN Val_Op_Emp ELSE 0 END) AS [30-90 Dias_Sum], COUNT_BIG(CASE WHEN (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) > 90) THEN N_Op_Imp ELSE 0 END) AS [+90 Dias_Count], SUM(CASE WHEN (Linha_Final = 'A') AND (N_Pri_Pres > 0) AND (DATEDIFF(dd, Dat_Venc, GETDATE()) > 90) THEN Val_Op_Emp ELSE 0 END) AS [+90 Dias_Sum]FROM A_Tua_Tabela GROUP BY Cod_Mun ORDER BY Cod_MunMas o ideal era usar um Cubo caso tenhas disponivel o Analisys Server.1 abraço