i have query which display following output.
AdmissionNo FirstName LastName SubjectName
0001 Piya Sharma Sub1
0001 Piya Sharma Sub3
0001 Piy Sharma Sub5
but i want following output.
please tell me pivot query or any other option to display following output.
AdmissionNo FirstName LastName SubjectName Sub1 Sub2 Sub3 Sub4 Sub5
0001 Piya Sharma Sub1 Yes No No No No
0001 Piya Sharma Sub3 No No Yes No No
0001 Piya Sharma Sub5 No No No No Yes