CodeXchange.org Addin for Visual Studio.NET

Code Snippet Preview

Review the code snippet before inserting it on your project.

Snippet Metadata
Summary:	Betoxz - Criar Pivot Tables
Language:	T-SQL
Author:	carlos martins
Author snippets RSS:
Culture:	pt
Bytes:	1303
Visual Studio 2005 Snippet:

Snippet Stats
Downloads:	0
Overall rating :	0
Average rating :

Snippet Preview

Code:

/*******************Este exmplo é para versão do Sql 2000*********************************/
/*****************************************************************************************/
select  year(DataCriacao) Ano
         , Janeiro = sum(case when month(DataCriacao)=1 then Total end) 
         , Fevereiro = sum(case when month(DataCriacao)=2 then Total end) 
         , Março = sum(case when month(DataCriacao)=3 then Total end)
         , Outubro = sum(case when month(DataCriacao)=10 then Total end) 
from pedido 
group by year(DataCriacao) 
order by year(DataCriacao);
/*****************************************************************************************/
            /*********************************************/

/*******************Este exmplo é para versão do Sql 2005*********************************/
/*****************************************************************************************/
Select Ano
    , [1] as Janeiro
   , [2] as Fevereiro
   , [3] as Março 
   , [10] as Outubro 
from (
   select year(DataCriacao) Ano,month(DataCriacao) Mes, Total from pedido
   )Pedido 
   pivot (sum(Total) for Mes in ([1],[2],[3],[10])) PedidoPivot
order by 1;
/*****************************************************************************************/
            /*********************************************/

Snippet Comments

Comments:

No comments for this snippet

Other snippets that may interest you..

Related Snippets

TDT - GridPage - Page_Init (C#)

CustomValitaor (C#)

(C#)

Get the file extension from a file path or file name (VB.NET)

grab record from db and subtracts it from variable (VB.NET)

With from Barcelona