forum

Home / DeveloperSection / Forums / Customer Order Monthly Report Using Pivot In SQL Server

Ask Question
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

08-Dec-2015

Pivot query help us to generate an interactive table that quickly combines and compares large amounts of data. We can rotate its rows and columns to see different summaries of the source data, and we can display the details for areas of interest at a glance. It also help us to generate Multidimensional reporting.

  SELECT * FROM (    
        SELECT c.CustomerName, CONVERT(CHAR(4), d.Orderdate, 100)  as [month],    
            ISNULL(d.amount,0) AS Amount    
            FROM [Order] d RIGHT JOIN Customer c    
            ON d.CustomerID=c.CustomerID)    
            AS s  PIVOT ( SUM(Amount)    
            FOR [Month] in (Jan, Feb, Mar, Apr, May, June, Jul,  
                             Aug, Sep, October, Nov, Dec)
        ) as CustomerOrder order by CustomerName

answer 415870812092047

Liked By