Click here to Skip to main content
15,614,571 members

Articles by Kannan K R (Article: 1, Tip/Trick: 1)

Article: 1, Tip/Trick: 1

RSS Feed

Average article rating: 4.17

Database Development
SQL Server
13 Sep 2010   Updated: 22 Sep 2010   Rating: 4.17/5    Votes: 5   Popularity: 2.91
Licence: CPOL    Views: 31,452     Bookmarked: 25   Downloaded: 245
Please Sign up or sign in to vote.
In this article, we see a stored procedure to create pivot tables with multiple summary functions from an existing table.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 0.00

15 Mar 2011   Updated: 15 Mar 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 6,411     Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
select ExDate, SUM(case when Dept='A' then expense else 0 end)[Store A Expense],SUM(case when Dept='B' then expense else 0 end)[Store B Expense],SUM(case when Dept='C' then expense else 0 end)[Store C Expense]from expenseTable where Dept in ('A','B','C') group by ExDate

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
Team Leader
India India
Kannan KR, Team Lead working in a Mobile Application Development Company in Noida, India. Having 8+ years of experience in Web, Mobile and Application Development. Focused on .Net, Java, VB, SQL Server and related technologies as both a career and a personal passion