حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

Create Crosstab query using PIVOT in SQL Server

makumbi

makumbi

SOLVED CLOSED ACTIVE ANSWERED
User: makumbi
Posted: on Oct 12, 2023 07:54 AM
Forum: SQL Server
Replies: 1
Views: 618

no	class	subject	Term	Termdata	Total	1	2
12	P7	Div.analysis	KCCA MOCK EXAMS	NULL	42	1	20
12	P7	Div.analysis	KCCA MOCK EXAMS	NULL	47	16	29
12	P7	Div.analysis	KCCA MOCK EXAMS	NULL	49	3	40
12	P7	Div.analysis	PRE PLE INTERNAL SET 8	NULL	49	19	27
12	P7	Div.analysis	PRE PLE INTERNAL SET 8	NULL	49	19	27
12	P7	Div.analysis	KCCA MOCK EXAMS	NULL	55	51	4
12	P7	Div.analysis	KCCA MOCK EXAMS	NULL	57	54	3
12	P7	Div.analysis	KCCA MOCK EXAMS	NULL	250	125	96
13	P7	Div.analysis %	KCCA MOCK EXAMS	NULL	42	1	20
13	P7	Div.analysis %	KCCA MOCK EXAMS	NULL	47	16	29
13	P7	Div.analysis %	KCCA MOCK EXAMS	NULL	49	3	40
13	P7	Div.analysis %	PRE PLE INTERNAL SET 8	NULL	49	19	27
13	P7	Div.analysis %	PRE PLE INTERNAL SET 8	NULL	49	19	27
13	P7	Div.analysis %	KCCA MOCK EXAMS	NULL	55	51	4
13	P7	Div.analysis %	KCCA MOCK EXAMS	NULL	57	54	3
13	P7	Div.analysis %	KCCA MOCK EXAMS	NULL	250	125	96
1	P7	ENG	PRE PLE INTERNAL SET 8	Term 111	37	0	2
1	P7	ENG	KCCA MOCK EXAMS	Term 11	42	0	0
1	P7	ENG	KCCA MOCK EXAMS	Term 11	46	0	3
1	P7	ENG	PRE PLE INTERNAL SET 8	Term 111	47	0	23
1	P7	ENG	KCCA MOCK EXAMS	Term 11	49	0	6
1	P7	ENG	PRE PLE INTERNAL SET 8	Term 111	49	0	16
1	P7	ENG	PRE PLE INTERNAL SET 8	Term 111	52	2	42
1	P7	ENG	KCCA MOCK EXAMS	Term 11	55	2	24
1	P7	ENG	PRE PLE INTERNAL SET 8	Term 111	56	0	36
1	P7	ENG	KCCA MOCK EXAMS	Term 11	57	3	34
1	P7	ENG	PRE PLE INTERNAL SET 8	Term 111	241	2	119
1	P7	ENG	KCCA MOCK EXAMS	Term 11	249	5	67
4	P7	MTC	PRE PLE INTERNAL SET 8	Term 111	40	1	2
4	P7	MTC	KCCA MOCK EXAMS	Term 11	42	0	0
4	P7	MTC	KCCA MOCK EXAMS	Term 11	47	0	1
4	P7	MTC	PRE PLE INTERNAL SET 8	Term 111	47	0	3
4	P7	MTC	KCCA MOCK EXAMS	Term 11	49	0	0

How can i create a crosss tab query to show Termdata as the header

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

dharmendr

dharmend...

0 1

Reply
User: dharmendr
Replied: on Oct 12, 2023 07:55 AM
Report

Use Pivot query.

Refer below link.

Generate dynamic columns using Pivot function in SQL Server

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

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.