Olá galera,
Tenho uma sentença em SQL e quero que ela fique em ordem crescente hoje ela está em ordem alfabetica.
Aguardo retorno.
Segue sentença abaixo
SELECT d.nome, ISNULL(SUM(JAN),0)JAN,
ISNULL(SUM(FEV),0)FEV, ISNULL(SUM(MAR),0)MAR, ISNULL(SUM(ABR),0)ABR, ISNULL(SUM(MAI),0)MAI, ISNULL(SUM(JUN),0)JUN, ISNULL(SUM(JUL),0)JUL,
ISNULL(SUM(AGO),0)AGO, ISNULL(SUM(SETE),0)SETE, ISNULL(SUM(OUTU),0)OUTU,
ISNULL(SUM(NOV),0)NOV, ISNULL(SUM(DEZ),0)DEZ
FROM (
SELECT B.NOME, SUM(A.VALORORIGINAL)JAN, NULL FEV, NULL MAR, NULL ABR, NULL MAI,
NULL JUN, NULL JUL, NULL AGO, NULL SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B(NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='01'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, SUM(A.VALORORIGINAL)FEV, NULL MAR, NULL ABR, NULL MAI,
NULL JUN, NULL JUL, NULL AGO, NULL SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='02'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, SUM(A.VALORORIGINAL)MAR, NULL ABR, NULL MAI,
NULL JUN, NULL JUL, NULL AGO, NULL SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='03'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR , SUM(A.VALORORIGINAL)ABR, NULL MAI,
NULL JUN, NULL JUL, NULL AGO, NULL SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='04'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR ,NULL ABR, SUM(A.VALORORIGINAL)MAI, NULL JUN, NULL JUL , NULL AGO, NULL SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='05'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR , NULL ABR, NULL MAI, SUM(A.VALORORIGINAL)JUN, NULL JUL, NULL AGO, NULL SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='06'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR , NULL ABR, NULL MAI, NULL JUL, SUM(A.VALORORIGINAL)JUL, NULL AGO, NULL SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='07'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR , NULL ABR, NULL MAI, NULL JUL, NULL JUL, SUM(A.VALORORIGINAL)AGO, NULL SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='08'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR , NULL ABR, NULL MAI, NULL JUL, NULL JUL, NULL AGO, SUM(A.VALORORIGINAL)SETE, NULL OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='09'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR , NULL ABR, NULL MAI, NULL JUL, NULL JUL, NULL AGO, NULL SETE, SUM(A.VALORORIGINAL)OUTU, NULL NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='10'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR , NULL ABR, NULL MAI, NULL JUL, NULL JUL, NULL AGO, NULL SETE, NULL OUTU, SUM(A.VALORORIGINAL)NOV, NULL DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='11'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
UNION ALL
SELECT B.NOME, NULL JAN, NULL FEV, NULL MAR , NULL ABR, NULL MAI, NULL JUL, NULL JUL, NULL AGO, NULL SETE, NULL OUTU, NULL NOV, SUM(A.VALORORIGINAL)DEZ
FROM FLAN A (NOLOCK) INNER JOIN GCCUSTO B (NOLOCK) ON
(A.CODCOLIGADA=B.CODCOLIGADA AND A.CODCCUSTO=B.CODCCUSTO)
WHERE
A.PAGREC='1'
AND STATUSLAN <>2
AND STATUSLAN <>3
AND MONTH(A.DATAVENCIMENTO)='12'
AND YEAR(A.DATAVENCIMENTO)='2009'
GROUP BY B.NOME
)D
GROUP BY D.NOME