Click here to Skip to main content
12,883,114 members (37,882 online)
Rate this:
 
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
Updated 19-Jan-13 21:20pm
v2
Comments
Sandeep Mewara 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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.170422.1 | Last Updated 20 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100