Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / customer order monthly report using pivot in sql server
Ask Question
Anonymous User
Anonymous User

Other

I am a content writter !

Message

1 Answers

Anonymous User
Anonymous User 08 Dec 2015
Report Abuse

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

Anonymous User

advertising