Click here to Skip to main content
15,890,438 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a table Structure Like this :
EdpNo FullName PeriodMonth ITaxAmount EduCess
16 RAJ KISHORE SHAW 4 1809 54
16 RAJ KISHORE SHAW 5 1812 54
16 RAJ KISHORE SHAW 6 3185 95
16 RAJ KISHORE SHAW 7 0 0
16 RAJ KISHORE SHAW 8 0 0
16 RAJ KISHORE SHAW 9 0 0
16 RAJ KISHORE SHAW 10 0 0
16 RAJ KISHORE SHAW 11 0 0
16 RAJ KISHORE SHAW 12 0 0
16 RAJ KISHORE SHAW 1 0 0
16 RAJ KISHORE SHAW 2 0 0
16 RAJ KISHORE SHAW 3 0 0
-----------------------------------------------------------------
And I want Output Like :
FullName 4 5 6 7 8 9 10
RAJ KISHORE SHAW 1809 1812 3185 0 0 0 0
RAJ KISHORE SHAW 54 54 95 NULL NULL NULL NULL


How should got this type of output.
Posted

1 solution

Hi,

Check this...

Simple Way To Use Pivot In SQL Query[^]

Hope this will help you.

Cheers
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900