Calculate running total and grand total using Pivot in SQL Server

yogeshc

SOLVED CLOSED ACTIVE ANSWERED
User: yogeshc
Posted: on Sep 22, 2017 05:10 AM
Forum: SQL Server
Answer: 1
Views: 13699

I have a marks table it contains all record of marks which are scored by student so i wants to show data in pivot table than bind to gridview here is my table structure

structure

here is my table data

tabledata

i wants like this

pivot

Download FREE API for Word, Excel and PDF in ASP.Net

yogeshc

0 2

Reply
User: yogeshc
Replied: on Sep 22, 2017 08:03 PM
Modified: on Sep 22, 2017 08:05 PM
Report

sir am getting records as below but i wants as i mention above

Subject	Max_Marks	UploadDate	1	2	3
DRAWING	20	9/22/2017	17	19	NULL
ENGLISH	20	9/22/2017	19	15	NULL
EVS	20	9/22/2017	18	18	NULL
GEN. KNOWLEDGE	20	9/22/2017	18	20	NULL
HINDI	20	9/22/2017	18	16	NULL
MATHEMATICS	20	9/22/2017	19	19	NULL
MORAL EDUCATION	20	9/22/2017	19	20	NULL

my sql query is

DECLARE @Sttudent_Id INT
SET @Sttudent_Id = 10003
 
SELECT * FROM
(
    SELECT [Subject],[Term],[Max_Marks],[Obt_Marks],[UploadDate] FROM Marks WHERE @Sttudent_Id = @Sttudent_Id
) as tbl
PIVOT(MAX(Obt_Marks) FOR [Term] IN ([1],[2],[3])) as PVT

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Calculate running total and grand total using Pivot in SQL Server

Company

Explore

Follow us

Contact Us