Click here to Skip to main content
15,886,518 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Table_Name:

CSS
Name    Dept    Date    marks
siva    it  8/29/2015 8:00  95
mani    cse 9/29/2015 8:00  87
naveen  it  9/29/2015 8:00  46
praveen cse 8/29/2015 8:00  78
guna    it  10/29/2015 8:00 89
dachu   cse 12/29/2015 8:00 88
kumar   it  11/29/2015 8:00 95
bharath cse 12/29/2015 8:00 87
ganesh  it  8/29/2015 8:00  46
vikram  cse 9/29/2015 8:00  78
deepak  cse 11/29/2015 8:00 89
manoj   it  10/29/2015 8:00 88
karthi  cse 8/29/2015 8:00  95
venkat  it  10/29/2015 8:00 87
sumanth cse 12/29/2015 8:00 46
shankar it  8/29/2015 8:00  78
dinash  cse 10/29/2015 8:00 89


I want the output is date vise to display the marks such as(Column_Name= kumar, Column_11/29/2015 8:00 = 95)



Name 8/29/2015 8:00 9/29/2015 8:00 10/29/2015 8:00 11/29/2015 8:00 12/29/2015 8:00
siva 95
mani 87
naveen 46
praveen 78
guna 89
dachu 88
kumar 95
bharath 87
ganesh
vikram 78
deepak 89
manoj 88
karthi 95
venkat 87
sumanth 46
shankar 78
dinash 89
Posted

1 solution

A Pivot should do - PIVOT[^].
 
Share this answer
 
v2

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