Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server
date	        sess    code   course
14-Jan-13	 1	CM	AFF
14-Jan-13	 3	CM	AFF
17-Jan-13	 1	NR	CTF
 

 
from the above i want the output as follows;
 

                    AFF (course)				
	      1   2    3   4  (sess)
 14-Jan-13    CM      CM
 
                    CTF     (course)				
	     1    2  3  4   (sess)
 17-Jan-13   NR
 

for getting a above output i tried the query as follows; but output is not getting;
query as follows;
 
SELECT *
FROM (
SELECT *
FROM [Tb_SCh_TIme_Table])
PIVOT(MAX([faculty_code])FOR [session] IN ([1],[2],[3] ,[4])) AS PVT
 
i tired the above query when i run shows error as follows;
 
Line 5: Incorrect syntax near '('.
from my above query what is the mistake please help me.
 

[edit]Code block added (not that the original indentation makes it a lot clearer) - OriginalGriff[/edit]
Posted 19-Jan-13 19:35pm
Edited 19-Jan-13 21:20pm
v2
Comments
Sandeep Mewara at 20-Jan-13 6:34am
   
Follow at one place: http://www.codeproject.com/Questions/530591/Ipluswantplustheplusoutputplusasplusfollowsplusinp

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

This is the third time you have posted this same question (see I want to secreate course wise report in datagridview in c sharp .net.[^]). Please do not repost the same issue but edit your original if you have extra information to show.
  Permalink  
v2

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 710
1 OriginalGriff 543
2 Abhinav S 318
3 thatraja 245
4 Tadit Dash 140
0 Sergey Alexandrovich Kryukov 8,322
1 OriginalGriff 4,790
2 Peter Leow 3,784
3 Maciej Los 3,515
4 Er. Puneet Goel 3,107


Advertise | Privacy | Mobile
Web04 | 2.8.140415.2 | Last Updated 20 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid